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

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 766321 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 10/5/2012 11:12:55 AM
Access Restriction Public


Within the url
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.
Sign in to post a comment.
Posted by Microsoft on 11/22/2013 at 2:08 PM
Hi there. the documentation has been updated per your feedback to include a more elaborate description. Thanks!
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.