asked
Database Mirroring between SQL 2008 & SQL 2012
Hello Everyone, Is it possible to set up a Database Mirroring between two different versions? I am trying to set up Database Mirroring between SQL Server 2008 and SQL server 2012, I am new to Database Mirroring & not able to find any help online. ALso, is it possible to set up database mirroring between different versions without Witness server? We only have one 2012 server if needed I need to setup Witness server on 2008 server Again is it possible? If it's possible to set up a Database Mirroring between SQL Server 2008 and SQL server 2012 can anyone please share a link with me or send me step by step details. I really appreciate all your help. Thanks in Advance. A.B
Nope. If you take a look at the documentation for SQL Server, [the Books Online][1], the very first stricture is that: > For a mirroring session to be > established, the partners and the > witness, if any, must be running on > the same version of SQL Server. That couldn't be much more clear, but it's clarified in the second: > The two partners, that is the > principal server and mirror server, > must be running the same edition of > SQL Server. [1]:
http://msdn.microsoft.com/en-us/library/ms366349.aspx
I saw this over on MSDN. It's worth a read:
http://blogs.msdn.com/b/ialonso/archive/2011/11/09/never-ever-set-up-a-database-mirroring-session-across-different-sql-server-editions-sku.aspx Remember, online, you can find a web site to support anything:
http://elvis-is-alive.com/
There may be a way to hack around it, but Microsoft is pretty clear. Personally, I'd follow what they say in order to ensure that what I have installed for any business I support will work as expected.
15 People are following this question.
