database mirroring failover error

Hi,

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

Thanks, Kiran

asked Jun 11 '10 at 12:18 PM in Default

Kiran 1
14 ● 4 ● 4 ● 5

(comments are locked)

1 answer:

From Database Properties (Mirroring Page) on MSDN:

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.

answered Jun 11 '10 at 12:34 PM

Matt Whitfield ♦♦
29.2k ● 56 ● 63 ● 87

Thanks for the reply..In my script, I am changing the operating mode to High safety and then issuing the SET PARTNER FAILOVER command. However, it is unable to failover as it is saying that the mirror instance is not caught up with recent changes.Should i have to wait for some time before i issue the SET PARTNER FAILOVER command?

Jun 11 '10 at 12:57 PM Kiran 1

Yes - I am not at my computer right now so I can't check to see if there os a way to tell if you're caught up...

Jun 11 '10 at 01:48 PM Matt Whitfield ♦♦

OK - you want to wait for mirroring_state in sys.database_mirroring to equal 6 for the database ID you are trying to fail over, I think...

Jun 11 '10 at 03:43 PM Matt Whitfield ♦♦

Thanks for the reply.I tried that, but thats not working..If you know any way to check if the mirror instance is caught up with recent changes before i execute the SET PARTNER FAILOVER statement, please let me know

Jun 11 '10 at 04:15 PM Kiran 1

Not working why, exactly?

Jun 11 '10 at 08:47 PM Matt Whitfield ♦♦

(comments are locked)