Home / server / Questions / 74034
In Process
blueberryfields
Asked: 2009-10-14 06:07:45 +0800 CST

Which tools are most commonly used to auto-encrypt backups for SQL Server 2005?

  • 772

I am looking to automate the encryption of my backups, and SQL Server 2005 does not appear to include built in functionality to do the work. Similar to the question here - Is it possible to configure SQL Server 2005 to auto-compress backups? - I am looking for a list of commonly used software to do the job

sql-server

3 Answers

  1. I have used SQL Backup from Red Gate for more than 2 years now and its awesome. It encrypts, compresses, recovers from network drop-outs and gives you object level restores from native backup files. They do a free 14 day trial, here: http://www.red-gate.com/products/SQL_Backup/index.htm

    Hope you give it a go, you wont be disappointed.

    Jonathan

    • 1

  2. Nope. Not with SQL 2005.

    You might want to read over this topic: Is it possible to configure SQL Server 2005 to auto-compress backups?

    A lot of those answers will apply to this one as well as compress & encrypt tend to go hand-in-hand.

    • 0

  3. With SQL 2005 you can't encrypt backups, but you can encrypt them using third party tools.

    Encryption and compression don't go hand-in-hand. Encrypted files are hard to compress, so if space is a concern, you might want to compress in stead of encrypt files and protect those compressed files with a password.

    • 0