Just curious whether it's possible to mirror databases across versions.
views:
251answers:
2
+3
A:
Yes and no.
Yes, it is possible to establish a mirroring session between 2008 and R2, as long as the R2 acts as a mirror. But as soon as a failover occurs and R2 becomes the principal, the R2 will upgrade the database to version 661 (the R2 database version). Since 2008 only understands version 655, it will no longer be possible to ever bring that database back online on the 2008 server.
Mirroring between different versions is often used to upgrade servers with minimal impact on production.
Remus Rusanu
2010-05-13 15:34:06
Thanks for the reply!
Dmitri Nesteruk
2010-05-13 17:25:38
A:
Thanks for that worthful information (nevertheless I should have known before I setup the new machine with SQL server 2008 R2...)
Mats
2010-07-12 13:37:47