Can Mirroring create problem when upgrade to different SP ?

HI All,

We are planing to upgrade our SQL Server 2005 SP2 to SP4.

We have mirroring implemented on this server .. Our Production server will be SP2 and development server will be upgraded to SP4. do this service pack upgrade create any problem in mirror. do it automatically come in sync once the patch upgrade or again we need to setup the mirroring for that database.

Do mirroring support the instance with different SP Version.


Basit Khan

more ▼

asked Sep 18, 2012 at 04:23 PM in Default

avatar image

basit 1
509 57 65 91

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

1 answer: sort voted first

You should be able to Pause the mirror and apply the SP. I personally do the following

  • Pause mirror

  • Patch partner

  • Resume mirroring (allow to catch up so there are no transactions pending)

  • Failover

  • Patch primary

Hope this helps. Only issue I can see with this is that during the patching process you have a single point of failure, but (touch wood) I have never had an issue patching just SPs.

Personally if you haven't done it before I would test first!

more ▼

answered Sep 18, 2012 at 07:11 PM

avatar image

10.9k 27 37 37

(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: Sep 18, 2012 at 04:23 PM

Seen: 773 times

Last Updated: Sep 18, 2012 at 07:12 PM

Copyright 2018 Redgate Software. Privacy Policy