I am using database mirroring with high performance(asynchronous) operating mode. When i am trying to failover i am getting the following error: "the mirror server instance is not caught up to the recent changes to database unable to failover"
could anyone please help me out with this
Answer by Matt Whitfield ·
If the mirroring session is running in high-performance mode, manual failover is not supported. To fail over manually, you must first change the operating mode to High safety without automatic failover (synchronous). After failover completes, you can change the mode back to High performance (asynchronous) on the new principal server instance.