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.

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. serverfault.com/questions/303566/… –  Mr. Flibble Aug 21 '11 at 19:34

3 Answers 3

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 http://www.r1soft.com/windows-cdp/. 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

 
discard

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.