Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Can anyone recommend a database backup utility, free or paid? Ideally it will

  • backup MSSQL & MySQL, but MSSQL only will suffice

  • allow backup of single tables

  • encrypt backups

Many thanks

share|improve this question
Thanks for the comments guys. I think I may have asked too general a question, so will ask more specifically in another question.… – Mr. Flibble Aug 21 '11 at 19:34
up vote 1 down vote accepted

There isn't a tool which allows for a backup of a single SQL Server database table. You can export each table using BCP however these wouldn't be consistent with each other and wouldn't be a viable backup model.

Native database backups can be encrypted if you enable TDE in SQL Server. You can also use third party products like HyberBac, LiteSpeed, SQL Backup to encrypt (and compress) backups.

share|improve this answer
Thank you mrdenny. – Mr. Flibble Aug 21 '11 at 20:09

I don't know of any floss tools that will do that for both MSSQL & MySQL. You might want to take a look at Their product for Linux works but involves loading a binary blob into the kernel "tainting" it, which may be a vendor support issue for you. I won't run binary blobs on production servers.

share|improve this answer

I use AutoMySQLBackup to backup my databases, it works pretty flawless.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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