Encrypting .bak files - Sql server 2005 RRS feed

  • Question

  • Hi all,

    What options are there available to encrypt .bak files in SS2005

    I'm aware of TDE in SS2008, but that seems to be only available in the Enterprise version? the company would only agree to upgrade to standard 2008 version.

    I'm aware I can password protect a .bak file, but that's not encrypted and can be opened in notepad.

    Should I be looking for third-party solutions?






    Sunday, September 5, 2010 2:44 PM


All replies

  • You might take a look at the PASSWORD option for the Backup command, beside that and keeping in mind that this is a deprecated functionality, password protection is weak and the backup is only gated not encrypted, you should consider using TDE or an external tool to encrypt backups.


    Jens K. Suessmeyer http://blogs.msdn.com/Jenss
    • Proposed as answer by Tom Li - MSFT Tuesday, September 7, 2010 9:43 AM
    Monday, September 6, 2010 5:52 AM
  • If it is so critical , do not place them on the filesystem, keep them in the safety place.. I agree with Jens that relaible solutuon is TDE
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, September 6, 2010 6:46 AM

    Please follow the link for using EFS without any tools to encrypt the database backup



    Sivaprasad S http://sivasql.blogspot.com Please click the Mark as Answer button if a post solves your problem!
    • Marked as answer by Meltdown61 Monday, September 13, 2010 11:40 AM
    Monday, September 6, 2010 7:24 AM
  • Thanks for all the replies,

    As we don't have the enterprise version of SS, we can't use TDE, so I'll go with Sivaprasad S' solution, thanks.



    Monday, September 13, 2010 11:42 AM