 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / January 2006how to encrypt db files
Came across the following on best practises as well " Use the SQL Server service account to encrypt database files with EFS." How do you set it up ? Just because it is on someone's best practices list, doesn't mean it should just be grabbed and executed. When you encrypt the files on the OS, you incur a performance hit everytime they need to be accessed to do the decrypt/encrypt. Since a database server never quits reading or writing to the files, this can be a rather heavy load on the machine and cause significant degradation in performance.  SignatureMike http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole views on the subject. It does not represent the views of any other person or entity either by inference or direct reference. > Came across the following on best practises as well > > " Use the SQL Server service account to encrypt database files with EFS." > > How do you set it up ? >decrypt/encrypt. Since a database server never quits reading or writing to Actually SQL2005 seems to close the file if no active query is running... --- AntiSpam/harvest --- Remove X's to send email to me. The server is supposed to hold the individual database files open and in a ready state regardless of user activity. Are you sure you don't have the autoclose property turned on for the database you are looking at? That is: select databaseproperty('<dbname>', 'IsAutoClose') -- *mike hodgson* http://sqlnerd.blogspot.com >>decrypt/encrypt. Since a database server never quits reading or writing to >> [quoted text clipped - 4 lines] >Remove X's to send email to me. > Hi Hassan, Encrypting your data files can be a prudent measure (MSDE instance on a field salesperson's laptop with customer data, for example). I wouldn't necessarily recommend it on the server side. Here is a nice how-to on encrypting your files using EFS... http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.