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.
| Author |
Topic |
|
dohamsg
Starting Member
22 Posts |
 Posted - 2012-05-03 : 10:19:31
|
| Hi,Is there any way to prevent my SQL Server2008 database file being attached to an instance of SQL Server?I don't want anyone to take my database file and attaching it to his SQL Server instance to view my data or change any database object.Thanks. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2012-05-03 : 12:29:34
|
| The only way to guarantee that is to make the server physically secure and limit network access to it, so someone can't copy it. You can also encrypt the database using Transparent Data Encryption, but that also requires you keep the encryption keys secure. |
 |
|
|
dohamsg
Starting Member
22 Posts |
Posted - 2012-05-06 : 05:07:44
|
| Hi, thanks.Does the Transparent Data Encryption, slows down querying process?Thanks. |
|
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-05-06 : 06:41:11
|
| Performance impact is 3-5% or better in Microsoft's performance tests. http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspxFor an existing database, TDE is probably the least intrusive method that you can use to encrypt, so that may be a price you are willing to pay.One other thing to keep in mind is that TDE can have adversely affect the performance of other databases on the same server even if those databases do not use TDE. |
|
|
|
|
|
|
How to Protect My Database File?