locked
Set password to MDF and LDF RRS feed

  • Question

  • Hello Everyone,

    Is it possible to set password to MDF and LDF file ?

    Saturday, April 19, 2014 12:48 PM

Answers

  • SQL Server doesn't password-protect database files.  The best practice to protect database files with proper file-level permissions.  Access to the database data from the database engine is controlled via SQL Server permissions. 

    If you are using Enterprise Edition, you can use TDE to further protect the files.


    Dan Guzman, SQL Server MVP, http://www.dbdelta.com

    • Proposed as answer by Uri DimantMVP Saturday, April 19, 2014 1:35 PM
    • Marked as answer by Sofiya Li Monday, April 28, 2014 9:33 AM
    Saturday, April 19, 2014 1:22 PM