Question on Encryption File System (EFS) with SQL Server

• Vladimir Sim

  Ten Centuries

  Points: 1310

  More actions

  July 5, 2006 at 4:02 am

  #91573

  Hi,

  If I want to provide more security for my SQL Server and want to

  use Window Server Encryption File System (EFS) for this protection.

  Is the following issues true,

  1. using EFS, the encrypted file will be encrypted. However, when it

  is copy to another NON-NTFS file system or OS, is the encryption still

  present in the file ? Is the file still encrypted.

  2. when EFS is in effect, other user cannot access or copy it. So, if

  my current database file which is encrypted using the EFS and my system

  have other backup software that is auto synchronising the database to

  another system. How can I ensure that the backup software will work without

  any problem ?

  3. Will EFS have any problem with antivirus or backup software ?

  4. If I need other system to access that encrypted file, how can I just let

  that system access it like opening it without any problem ? Please advise.

  Thank you

• July 10, 2006 at 8:00 am

  This was removed by the editor as SPAM

• Mark Harr

  SSCrazy Eights

  Points: 9921

  More actions

  July 10, 2006 at 9:38 am

  #648280

  Brian Kelly (of this site) wrote several execellent articles on this topic that address your questions.  Start at http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp

  Hope this helps

  
  
  Mark