1

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

Mr. Flibble
  • 723
  • 3
  • 13
  • 23
  • Thanks for the comments guys. I think I may have asked too general a question, so will ask more specifically in another question. http://serverfault.com/questions/303566/a-utility-to-backup-single-tables-on-mssql – Mr. Flibble Aug 21 '11 at 19:34

3 Answers3

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.

John Gardeniers
  • 27,458
  • 12
  • 55
  • 109
Joshua Hoblitt
  • 675
  • 4
  • 11
1

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.

mrdenny
  • 27,174
  • 4
  • 41
  • 69
0

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

Pedro Lobito
  • 479
  • 1
  • 5
  • 13