mirroring a TDE encrypted database

• mallesh.nayak2002

  SSC Enthusiast

  Points: 101

  More actions

  September 10, 2010 at 10:45 am

  #144967

  please help me with steps as i am unable to mirror a TDE encrypted database.

  it says failed to alter database encryption key at mirror server when i try to create encryption.

• SQLBuddy123

  One Orange Chip

  Points: 28294

  More actions

  September 10, 2010 at 2:51 pm

  #1219518

  Hi Mallesh,

  Please check this..

  http://blogs.msdn.com/b/sqlserverfaq/archive/2009/03/31/setting-up-database-mirroring-in-sql-server-2008-using-t-sql-when-the-database-is-encrypted-using-transparent-data-encryption.aspx

  Thank You,

  Best Regards,

  SQLBuddy

• Tac11

  SSCertifiable

  Points: 6980

  More actions

  August 9, 2013 at 8:36 am

  #1640167

  Hi Mallesh,

  r u able to do that? plz let me know