locked
How to encrypt database backup RRS feed

  • 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


    Sean Gallardy | Blog | Twitter

    • Proposed as answer by Fanny Liu Friday, April 19, 2013 7:18 AM
    • Marked as answer by Fanny Liu Tuesday, April 23, 2013 9:24 AM
    Thursday, April 18, 2013 4:39 PM
    Answerer

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


    Sean Gallardy | Blog | Twitter

    • Proposed as answer by Fanny Liu Friday, April 19, 2013 7:18 AM
    • Marked as answer by Fanny Liu Tuesday, April 23, 2013 9:24 AM
    Thursday, April 18, 2013 4:39 PM
    Answerer
  • 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