user3406790
user3406790

Reputation: 11

SQL Server encrypt mdf file

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

Answers (1)

alroc
alroc

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

Related Questions