Post reply

Mirroring setup between SQL 2008 to SQL 2008 R2

  • August 17, 2011 at 11:48 am

    #241787

    Hi All,

    Can DB mirroring be setup between SQL Server 2008 Enterprise and SQL Server 2008 R2 Enterprise Edition?

    We are migrating to another H/W and also upgrading to 2008 R2, So i was going with DB mirroring, Can somebody say if this is the right approach?

    If not what is the right approach? the DB is around 300 GB.

    Thanks

  • August 17, 2011 at 11:59 am

    #1369776

    No. That setup is supported only during an upgrade and only with 2008 as the principal and 2008 R2 as the mirror (the other way around will not work at all, databases cannot be downgraded)

    Mirroring needs to be between instance of the same version, preferably the same service pack too.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 17, 2011 at 1:45 pm

    #1369823

    i want to do mirroring making 2008 as principal and 2008r2 as mirrored. will that work?

  • August 17, 2011 at 2:09 pm

    #1369839

    It'll work, partially. It is not a supported config, it's not supposed to be used for anything other than a rolling upgrade and if the mirroring ever fails over you will not be able to fail back.

    There's really little use in a HA scenario that you can't fail over to without problems. Rather don't. Principal and mirror should be the same version. Either both 2008 or both 2008 R2.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 17, 2011 at 2:50 pm

    #1369863

    Thanks, It would be great if you can give me a reference/documents.

    What will be the alternative approach for this, T-Replication? if not Backup/Restore.

    Thanks

  • August 17, 2011 at 3:25 pm

    #1369880

    Books Online is your reference.

    As for an alternative, the alternatives you've listed have the same problem, once the second server (R2) becomes the active server you cannot in any way fail back.

    Either install 2008 on both or install 2008 R2 on both. HA with mixed versions is just asking for all sorts of trouble.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply