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

Answer 1

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

---

Sean Gallardy | Blog | Twitter

Answer 2

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.

Answer 3

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.