Poster – Database mirroring in SQL Server 2008 R2

Database mirroring in SQL server 2008 R2

As part of some investigations into SQL Server Database Mirroring I did this diagram to show how it works and the pro’s and con’s.

While mirroring is deprecated and will be removed in future versions of SQL server, it is still there in SQL 2014 virtually unchanged and is a good solution for customers with Standard Edition and who can’t or won’t use clustering (SQL clusters aren’t supported in Hyper-V replicas).

Download the PDF here.