Mirroring with different sp's

• simon4132-806507

  Mr or Mrs. 500

  Points: 580

  More actions

  September 11, 2012 at 1:09 pm

  #261719

  Hi,

  I have 2 machines mirroring with sql 2005 (and a witness)

  Recently i upgraded the mirror machine to sp4.

  The primary machine is sp2.

  I don't really want to upgrade the primary to sp4 simply because it is a prod environment. I only upgraded the mirror to try and fix an issue but it turned out the issue was something else (now resolved).

  I realise ideally both machines should be exactly the same version, however will mirroring with one on sp2 and one on sp4 actually cause any problems?

  Thanks

  Simon

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 11, 2012 at 1:17 pm

  #1536451

  My question is why do you want to keep the production system at SP2?

• simon4132-806507

  Mr or Mrs. 500

  Points: 580

  More actions

  September 11, 2012 at 1:24 pm

  #1536455

  Hi,

  Simply because it works.

  'if it aint broke don't fix it'

  This is a heavily used production system. To upgrade you have to pause mirroring and disconnect the mirror. If we got any problems during or resulting from the upgrade it would not be good.

  There are no changes between sp2 and sp4 that we need.

  Thanks

  Simon

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  September 11, 2012 at 1:38 pm

  #1536465

  simon4132-806507 (9/11/2012)

  ---

  Hi,

  Simply because it works.

  'if it aint broke don't fix it'

  This is a heavily used production system. To upgrade you have to pause mirroring and disconnect the mirror. If we got any problems during or resulting from the upgrade it would not be good.

  There are no changes between sp2 and sp4 that we need.

  Thanks

  Simon

  Why would you need to pause and disconnect the mirror? You already have SP4 installed on the mirror. All you would have to do is failover to the mirror. Upgrade the production server (which would now be the mirror), there may be a reboot, but with everything running on the mirror and with a witness, this would not stop any processing. Log records would queue during the reboot, but once the system was back up the mirror would syncronize again, and once in sync you could fail back to the production system.

  The only thing I would do is schedule this during a time frame of low use (night or weekend).

  It may not be broke, but what support you can get will be for SQL Server 2005 SP4, not SP2.