Avatar of vbplayer

asked on 

Encrypted Database Mirror Error

I'm using MS SQL 2008 Version 10.0.1600.22 RTM Enterprise Edition (64-bit). I can mirror a database with a witness server without an issue. But, when I try and mirror a database that has TDE encryption on I receive the following error. I can mirror it fine before the encryption but not after the encryption. There is nothing about the error in the SQL logs for event logs.

An error occurred while starting mirror.
  Alter failed for Database 'test2'. (Microsoft.SqlServer.Smo)
     Alter failed for DatabaseEncryptionKey 'Microsoft.SqlServer.Management.Smo.ObjectkeyBase',
     An exception occurred while executing a Transact-SQL Statement or batch. (Microsoft.Sqlserver.ConnectionInfo)
     Database 'test2' cannot be opened. It is in the middle of a restore. (Microsoft SQL Server, Error: 927)

Microsoft SQL Server 2008

Avatar of undefined
Last Comment

8/22/2022 - Mon