MySql Backup

Welcome Guest Search | Active Topics | Log In | Register
question on the tool Options · View
Guest
#1 Posted : Tuesday, August 3, 2010 10:56:06 PM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
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
ruslan
#2 Posted : Wednesday, August 4, 2010 10:21:33 AM
Rank: Administration

Groups: Administrators, Registered

Joined: 8/10/2009
Posts: 437
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
Guest
#3 Posted : Wednesday, August 4, 2010 10:44:02 AM
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 1,024
Administrator,

Thank you so much for answering my questions

Regards
Sree
Alexander Omelchenko
#4 Posted : Friday, July 29, 2016 3:29:01 AM
Rank: Advanced Member

Groups: Administrators, Registered

Joined: 12/23/2015
Posts: 457
Please feel free to contact us on any issues or concerns.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.

©Pranas.NET Sql Server Backup MySql Backup Free SQl Backup SQL Backup Master Employee monitoring software Web Scraping Azure SQL Database Backups ergonotes.com