SS 2005 SP2 upgrade to SP3 with DB mirroring RRS feed

  • Question

  • Hi, I have 2 enterprise editions of SQL Server 2005 Ent with SP2.  I have a setup of many DBs on one of the servers that act as principals and I have all the mirrors in the 2nd box. No witness.

    I need to upgrade both boxes to SP3 and I am not sure what the sequence is. In other words...Do I upgrade the mirror first or the principal? Do I suspend mirroring before upgrading? or it does not matter? Etc.

    If anyone has done an upgrade like this I will appreciate any hints.


    Thursday, May 7, 2009 8:17 PM

All replies