Mirroring between SQL Server 2005 and 2008??

Posted on 2008-11-20
Last Modified: 2012-05-05
Hi all

does anyone know if it is possible to setup database mirroring between a SQL Server 2005 and 2008?

Question by:nicolajsb
    LVL 8

    Accepted Solution

    Yes you should be able to setup mirroring between 2005 and 2008, but some of the new features of 2008 won't be available like automatic page repair.

    Author Comment

    perfect! I'll give it a try then :-)

    Author Comment

    Just tested.... and it only works one way :-(

    I can mirror a database from a 2005 to a 2008 and it works.... but when I make a failover the 2008 server becomes principal but the mirroring is suspended and I can't resume it.


    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now