November 17, 2010 at 9:05 am
What is the best way to protect your SQL 2005 backups? I don't beleive it has an encryption feature but I see a PASSWORD option in the BACKUP DATABASE command.
Any ideas?
Thanks
November 17, 2010 at 9:12 am
protection from what? unauthorized access? you can use the password clause of the backup command.
You should take tape backups or copy backups to remote location so that your backup copy remains intact should disaster strikes.
November 17, 2010 at 9:54 am
Even though the "password" option encrypts the backup file, the encryption is not strong enough. You can encrypt the entire database using TDE or use a third party tool to encrypt the backup files.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 17, 2010 at 10:21 am
LiteSpeed supports encrypted backups.
Redgate web site says their Backup Pro (not Lite) supports encrypted backups.
November 17, 2010 at 10:28 am
Adiga (11/17/2010)
Even though the "password" option encrypts the backup file, the encryption is not strong enough. You can encrypt the entire database using TDE or use a third party tool to encrypt the backup files.
Transparent Data Encryption (TDE) is only available in 2008 Enterprise or Developer Edition, not SQL 2005.
November 17, 2010 at 10:38 am
Transparent Data Encryption (TDE) is only available in 2008 Enterprise or Developer Edition, not SQL 2005.
Did not check the forum while responding 😉
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 23, 2010 at 5:29 am
Using the PASSWORD option in SQL Server backups only require that you be able to supply the same password during restore operations. It does not encrypt the data in any way. Try it for yourself: run 2 backups of the same database, one with and one without the PASSWORD option. Open both files using a text editor. The backed up database contents are identical in both files.
SQL BAK Explorer - read SQL Server backup file details without SQL Server.
Supports backup files created with SQL Server 2005 up to SQL Server 2017.
December 7, 2010 at 12:14 pm
One other way is to use Vormetric software to encrypt the drive itself where the files are located. Its got pretty good encryption and is widely used enterprise solution.
December 7, 2010 at 12:25 pm
Redgate's SQL Backup does in fact encrypt with either 128 or 256 bit encryption, your choice, as well as multiple levels of compression for the database dump.
Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply