Have Geek Brain

Can SQL Server 2008 and SQL Server 2008R2 databases be mirrored?

Just wondering if it is possible to mirror the versioned databases.

+2


a source to share


1 answer


Yes and no.

Yes, it is possible to establish a mirroring session between 2008 and R2 if R2 acts as a mirror. But as soon as the failover occurs and R2 becomes primary, R2 will upgrade the database to version 661 (the R2 database version). Since 2008, it only understands version 655, and it will no longer be possible to return this database to the 2008 server.



Mirroring between different versions is often used to upgrade servers with minimal impact on production.

+4


a source






More articles:


All Articles