Re: how to encrypt db files

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.

--
Mike
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.
"Hassan" <Hassan@xxxxxxxxxxx> wrote in message
news:exfOsOKIGHA.1424@xxxxxxxxxxxxxxxxxxxxxxx
> 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 ?
>
>


.