none
Restore SQL database encrypted with EFS RRS feed

  • Question

  • With EFS I encrypted SQL Server databases which DPM backed up. I want to restore to another SQL Server but the restore fails. Error number 5: Operating System error access is denied.

    I'm sure I have the EFS set correctly on both servers. If I detach the database, copy the MDF and LDF file to the destination server then I can attach to the database.

    Has anyone done this? Does anyone know of documentation?

    Thanks,


    Tom Morris


    • Edited by RCOTom Wednesday, January 30, 2013 6:10 PM
    Wednesday, January 30, 2013 6:10 PM

All replies

  • Hi Tom,

    You should see this post : http://serverfault.com/questions/58887/sql-server-error-attaching-mdf-file-encrypted-via-encrypted-file-system-efs

    Stephane


    Please remember to click “Mark as Answer” on the post that helps you. This posting is provided "AS IS" with no warranties. knowledge is valid only if it is shared by All.

    My DPM blog Yet Another DPM Blog

    Wednesday, January 30, 2013 9:22 PM