Solved

SQL Server mirror 10.5 to 10.0 ?

Posted on 2011-09-23
1
271 Views
Last Modified: 2012-05-12
Hi.  We have a newer SQL Server running v10.5 (aka "SQL Server 2008 r2"), and we are thinking of mirroring it to our old SQL Server running v10.0 (aka "SQL Server 2008") ....
Is this possible?
I've read that you can mirror from 64-bit to 32-bit and vice-versa, but haven't seen any mention of mirroring to a (slightly) different version of SQL Server.

Thanks.
0
Comment
Question by:Rob Rudloff
1 Comment
 
LVL 8

Accepted Solution

by:
venk_r earned 350 total points
ID: 36588903
It'll work, partially. It is not a supported config,. if the mirroring ever fails over you will not be able to fail back.

There's really little use in a HA scenario that you can't fail over to without problems. Rather don't. Principal and mirror should be the same version. Either both 2008 or both 2008 R2.

0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

743 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

15 Experts available now in Live!

Get 1:1 Help Now