0

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

Community
  • 1
blueberryfields
  • 757
  • 1
  • 7
  • 17

3 Answers3

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

Fatherjack
  • 419
  • 3
  • 12
0

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.

Community
  • 1
Chris_K
  • 3,444
  • 6
  • 43
  • 45
0

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.

Jeroen Landheer
  • 468
  • 1
  • 6
  • 14
  • The second paragraph was apprently in response to my answer. It might've made more sense to put it as a comment on said answer... Also, please notice the word "tend" in my answer -- but I don't currently know anyone compressing without encrypting or vice-versa – Chris_K Oct 13 '09 at 14:18