Post reply

Mirror setup

  • June 9, 2011 at 5:46 am

    #251683

    Can have Principle server on SQL 2005, Sp3 , Enterprise edition and

    Mirror server on SQL 2005, Sp2 , Enterprise edition?

    Will my mirror setup work?

    Thanks

  • June 9, 2011 at 10:32 am

    #1336496

    I wouldn't bet on it. There's no way of telling what functions, procs, or object changes (datatypes, system tables) happened between SPs to fix whatever problems Microsoft may have found between SPs.

    Your best bet is to upgrade everything to the same service pack level. Otherwise, you're just asking for trouble, whether or not the mirror setup works.

    EDIT: I should add the reason I don't think you should do it this way is because you're sending data from a higher level of SQL server to a lower level of SQL Server, and that never ends well.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • June 9, 2011 at 10:35 am

    #1336500

    Thanks a lot. we are upgrading our server this weekend. Hope that will resolve any issues

  • June 9, 2011 at 10:43 am

    #1336507

    I hope it will too.

    Let us know if you have any other questions.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Viewing 4 posts - 1 through 3 (of 3 total)

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