|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Hello,
I am a new user for this tool. I have couple of questions, those are
1) What is the maximum size of the database that this tool can handle
2) Can we handle the multi database back up at a time, if so how many max with professional version
3) Is there any chance for the database got corrupted while backing up the database using this tool.
4) If we have a database that was corrupted and by mistake we (DBAs) didn't noticed the corruption, what kind of corrective actions will this tool can take while backing up.
Thanks in advance for answering the questions
Sree
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 350
|
There's a very simple answer to your question: see how BACKUP DATABASE command works. SQLBackupAndFTP will run just the same.
In more detail:
1) There are no limits to the size of your database other then physical limitations of your server. Note however that if your database is huge, like 10-20GB, you probably need something more sophisticated than full DB backups, like partial of file backups that our tool does not have. (One of our customers was creating 68GB file with will database backup. So you can do it if you want, but probably shouldn't)
2)There is no limit on number of DB in Standard or Prof versions
3)In theory to be completely protected from corruption, the proper scenario would be to run CHECKDB before and RESTORE WITH VERIFYONLY after that backups. So far we don't see the need to integrate it into our program because not a single user has complained about corrupted database in the history of SQLBackupAndFTP. And at the moment we have over 43000 installations.
4)Have as many full backups (vs differential) as possible and store them on different servers
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
Administrator,
Thank you so much for answering my questions
Regards
Sree
|
|
|
|
|
