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.
asked Sep 18, 2012 at 04:23 PM in Default
You should be able to Pause the mirror and apply the SP. I personally do the following
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!