question

Kiran 1 avatar image
Kiran 1 asked

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

sql-server-2005database-mirroring
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered

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.

9 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kiran 1 avatar image Kiran 1 commented ·
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?
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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...
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
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...
0 Likes 0 ·
Kiran 1 avatar image Kiran 1 commented ·
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
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
Not working why, exactly?
0 Likes 0 ·
Show more comments

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.