Reputation: 11
I have a database SQL server ,so I have 2 files (mdf and log). how to protect mdf file from attach
Upvotes: 0
Views: 1274
Reputation: 28194
SQL Server Transparent Data Encryption can prevent people from using the files elsewhere unless they have the appropriate certificates.
But if they've gained access to the server to the point where they can access those files directly, you have to consider the possibility that it's completely compromised.
Upvotes: 4