locked
Mirroring and Build Levels RRS feed

  • Question

  • All,

     

    Is anyone aware if the database engine build levels will affect the mirroring process. we're in the process of upgrading a PROD environment to a new build however like to delay onto the disaster recovery (DR) server in case of issues. The DR is the mirror in the setup and so would have a differnet build level.

     

    Is this likely to affect anything? All info seems to point to only versions differences causing a problem but not the build.

     

    Is someone able to confirm this.

     

    Thanks......

    Friday, November 30, 2007 12:28 PM

Answers

  • Hi Wayne,
                  It should'nt be a problem, since it does satisfy the system requirements to configure mirroring. You need to have Sql server 2005 with SP1 or more so you can configure mirroring with SP2 + cumulative update 4

    - Deepak
    Sunday, December 2, 2007 7:59 AM
  •  

    This should not affect , but i strongly recommend you to go through

     

    http://support.microsoft.com/kb/926824

    How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring

     

     

    Monday, December 3, 2007 8:11 AM

All replies

  • A quick response to this would be greatly appreciated. For more clarity the upgrade is from SP2 to Cumulative Update 4 so this is nothing as extreme as an early SP upgrade.

     

     

    Many Thanks in advance.

     

    Friday, November 30, 2007 1:28 PM
  • Hi Wayne,
                  It should'nt be a problem, since it does satisfy the system requirements to configure mirroring. You need to have Sql server 2005 with SP1 or more so you can configure mirroring with SP2 + cumulative update 4

    - Deepak
    Sunday, December 2, 2007 7:59 AM
  •  

    This should not affect , but i strongly recommend you to go through

     

    http://support.microsoft.com/kb/926824

    How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring

     

     

    Monday, December 3, 2007 8:11 AM