question

AliRashid avatar image
AliRashid 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
sql-server-2008sql-server-2008-r2sql-server-2012mirroringdatabase-mirroring
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
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
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thank you Grant, but it's been said online that it's possible and doable.
0 Likes 0 ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.