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.

Thanks

Basit Khan

asked Sep 18 '12 at 04:23 PM in Default

basit 1
439 ● 36 ● 54 ● 80

(comments are locked)

1 answer:

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!

answered Sep 18 '12 at 07:11 PM