Reviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser : Detach/Attach. Detach the mirror database, move the transaction log file to a different location, and then attach the database. This won’t work because a mirror database (being in the “restoring” state) can’t be detached / attached. : Perform a manual failover to switc..
more »