locked
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?

    Regards

    Melt

     

     

     

    Sunday, September 5, 2010 2:44 PM

Answers

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


    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

    http://msmvps.com/blogs/gladchenko/archive/2005/04/15/42299.aspx

     


    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.

    Regards

    Melt

    Monday, September 13, 2010 11:42 AM