Home Forums SQL Server 2008 SQL Server 2008 - General Restored backup database and now encryption doesn't work. RE: Restored backup database and now encryption doesn't work.

  • July 26, 2010 at 1:00 am

    #1198032

    You need to create the encrytion key from the backup of the encrytion key from the source DB server.

    Please check the following article:

    http://www.sqlservercentral.com/articles/Transparent+Data+Encryption/66334/

    "More Green More Oxygen !! Plant a tree today"