Home / server / Questions / 303396
Accepted
Mr. Flibble
Asked: 2011-08-21 13:10:39 +0800 CST

What database backup utility should I use?

  • 772

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

sql database-administration database-backup

3 Answers

  1. 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.

    • 1
  2. Best Answer

    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.

    • 1

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

    • 0