Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What is the best software that can backup mysql and ms sql databases automatically?

Thanks

share|improve this question

closed as not constructive by HopelessN00b, Dave M, Michael Hampton, Jay, pauska Mar 27 '13 at 0:26

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Are you looking for a single software package that can do both? You may want to clarify. –  jgardner04 Nov 16 '10 at 18:54
add comment

4 Answers

For MySQL, I wrote a shell script to weekly full backup and daily incremental backup to a FTP server.

PS: Can you define "best"?

share|improve this answer
    
I also do scripts but my boss told me that we should have a centralized backup plan for us to administer backups easily. –  jose Nov 11 '10 at 8:52
    
What I mean of the word "best" is like most recommended. –  jose Nov 11 '10 at 8:53
add comment

Definitely (for linux) automysqlbackup from http://sourceforge.net/projects/automysqlbackup/.

For windows mysql server you can use the scheduled backup tool from mysql administrator application.

For MS SQL I use SQL script executed from scheduled tasks. Here is a good one.

To upload automatically remotely (from windows) on a FTP server you can use Fling.

share|improve this answer
    
The user asks for the best, which likely is a high priced backup package. Granted, poor wording of the question, but then this is the posters responsibility. –  TomTom Oct 26 '11 at 4:26
add comment

Any of the Enterprise backup applications can handle this. Legato, CommVault, Backup Exec, etc. They can backup MySQL, MSSQL, Windows, Linux, etc. All it takes it buying the correct plugins.

share|improve this answer
add comment

For MSSQL, a SQL Agent job can do that for you. It's built right into the SQL Server installation.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.