Setting Up Mirroring With TDE


  • I am having troubles setting up a mirrored pair while using TDE.

    I am able to successfully setup mirroring on a non-encrypted database

    I am able to successfully setup TDE on the primary node and restore the database and associated certificates on the secondary node, provided that the database is fully recovered on the secondary node.


    I am not able to get mirroring to work while TDE is running.  When I try to setup mirroring I get an error that says that it can't open the database on the secondary node to modify it.  (Which makes sense because it is supposed to be restored with no recovery.)

    Any help?

    Thursday, February 2, 2017 1:20 AM

All replies