Answered by:
How to encrypt database backup

Question
-
Hi,
We are sending database backup to vendor for troubleshooting. Vendor have secure ftp site. We just want to make sure backup file is secure. I want to encrypt database backup. How to do that? or is there any way to send database backup to vendor in secure way?
Thanks
- Changed type Tom Phillips Thursday, April 18, 2013 5:52 PM
Thursday, April 18, 2013 4:28 PM
Answers
-
Hello,
There are many different options in terms of encrypting the backup files:
1. If the database is using Transparent Data Encryption (TDE) then the backup is already encrypted.
2. The use of an external 3rd party tool such as 7zip, WinRAR, WinZip, etc that can do encryption.
3. The use of 3rd party SQL Server specific tools that have this feature built in, such as offerings from Quest, RedGate, etc.
-Sean
Thursday, April 18, 2013 4:39 PMAnswerer
All replies
-
Hello,
There are many different options in terms of encrypting the backup files:
1. If the database is using Transparent Data Encryption (TDE) then the backup is already encrypted.
2. The use of an external 3rd party tool such as 7zip, WinRAR, WinZip, etc that can do encryption.
3. The use of 3rd party SQL Server specific tools that have this feature built in, such as offerings from Quest, RedGate, etc.
-Sean
Thursday, April 18, 2013 4:39 PMAnswerer -
The simplest way is to use winzip with a password.
There is a backup password, however it is only marginally secure and can be easily bypassed.
Thursday, April 18, 2013 5:53 PM -
there is one option when you backup the database.
backup database dbname with password or mediapassword.
but the two options wll be discarded in the next version.
If you haven't all the things you want,be grateful for the things you don't have that you didn't want.
Friday, April 19, 2013 2:41 AM