Database Restoring fail on another Sql Server Instance after Disabled TDE in Sql Server 2008 Sp1 RRS feed

  • Question

  • Hi,

    I am using Sql Server 2008 SP1, i have enabled TDE  for a database. but when i disable TDE from database, and then take Database backup then i am not able to restore database into another instance of Sql Server 2008 SP1.

    Getting following error  when restoring DB..


    Processed 168 pages for database 'AA', file 'AA' on file 1.
    Processed 1 pages for database 'AA', file 'AA_log' on file 1.
    Msg 33111, Level 16, State 3, Line 1
    Cannot find server certificate with thumbprint '0xCEF83E2CFB4DF11B854F9547B68A850477327D85'.
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.



    Mark As Answer If My Reply Is Helpful
    Neeraj Bhandari
    Saturday, October 15, 2011 2:10 PM


All replies