Mirroring between SQL Server 2005 and 2008??

Posted on 2008-11-20
Medium Priority
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
  • 2

Accepted Solution

digital_thoughts earned 2000 total points
ID: 23004626
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

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

Author Comment

ID: 23104582
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…

809 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