x

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

more ▼

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

Kiran 1 gravatar image

Kiran 1
14 5 5 5

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

1 answer: sort newest

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

Matt Whitfield gravatar image

Matt Whitfield ♦♦
29.4k 61 65 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, 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1950
x57

asked: Jun 11, 2010 at 12:18 PM

Seen: 2845 times

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