Search

Books Online provides incorrect statement regarding Database Mirroring between versions by retracement

Active

4
0
Sign in
to vote
Type: Bug
ID: 766321
Opened: 10/5/2012 11:12:55 AM
Access Restriction: Public
0
Workaround(s)
0
User(s) can reproduce this bug
Within the url http://msdn.microsoft.com/en-us/library/ms189053.aspx#Restrictions
at the section titled "Restrictions",

the comment states "the principal and mirror server instances must be running on the same version and edition of SQL Server".

This statement is misleading at best, since Mirroring to a lower version of SQLServer to an upper version of SQL Server is possible, certainly if the lower versions are the correct upgrade path service packs. I have not tested inter-edition upstream mirrors yet, but I see no reason why that would not work either (especially assuming that the lower stream database does not use higher edition level functionality).

So to summarize, . You CAN Mirror a database from SQL Server 2005/ 2008/ R2 -> 2012. It is known as an "upstream mirror". You should ensure that your service packs are correct for the lower version 2005 =>SP4, 2008=>SP2 and 2008R2=>SP1. Also use SSMS 2012 if you are doing a GUI based mirror setup.
Upon fail-over to the upstream higher version the mirror will be broken and mirroring will be suspended. It is not possible to reverse mirroring to a downstream version.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

Documentation

Operating System

Not Applicable

Operating System Language

Not Applicable

Steps to Reproduce

Simply attempt database mirroring to an upstream SQL 2012 edition using the prerequisites I have mentioned.

Actual Results

Database mirroring will only go upstream.

Expected Results

Database Mirroring will continue to function until failover after which, the database mirroring will be suspended and should subsequently be removed for the database.

Platform

 

Virtualization

 
File Attachments
0 attachments
Sign in to post a comment.
Posted by Microsoft on 11/13/2012 at 3:33 PM
Thank you for pointing out this defect. Yes, the statement regarding database mirroring in that topic is inaccurate. We will revise per your recommendation in the next documentation refresh.
Sign in to post a workaround.