Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQL Server Security

Author  Topic 

rajeshpittan
Starting Member

1 Post

Posted - 2011-10-15 : 09:03:38

Has anybody know how to secure MDF and LDF file for not to attach and open in another computer.


R. Pittan

Sachin.Nand

2937 Posts

Posted - 2011-10-16 : 04:56:18
You can try TDE(comes only with Developer and Enterprise edition).You cannot prevent the MDF and LDF file from being attached to another computer but though attached the data would be in encrypted format till the user does not has the necessary certificates and master keys to decrypt them which were initially used to encrypt them.

PBUH

Go to Top of Page

paultech
Yak Posting Veteran

79 Posts

Posted - 2011-10-16 : 06:41:38
find more details about Understanding Transparent Data Encryption (TDE)

http://msdn.microsoft.com/en-us/library/bb934049.aspx



good luck

paul Tech
Go to Top of Page
   

- Advertisement -