database mirroring failover error


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

more ▼

asked Jun 11, 2010 at 12:18 PM in Default

avatar image

Kiran 1
14 5 5 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 11, 2010 at 12:34 PM

avatar image

Matt Whitfield ♦♦
29.5k 62 66 88

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, 2010 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, 2010 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, 2010 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, 2010 at 04:15 PM Kiran 1

Not working why, exactly?

Jun 11, 2010 at 08:47 PM Matt Whitfield ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 11, 2010 at 12:18 PM

Seen: 13827 times

Last Updated: Jun 11, 2010 at 12:52 PM

Copyright 2018 Redgate Software. Privacy Policy