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.
Senior consultant and company director at The Full Circle. Passionate about automation scripting, end user experience and cloud technology.