Summary
Database mirroring is one of the most significant SQL Server features to come along in a long time. This feature has provided a way for users to get to a minimum level of high availability for their databases and applications without having to use complex hardware and software configurations (as are needed with MSCS and SQL Server Clustering configurations).
To mirror a database, you essentially ask for a complete copy of a database to be created and maintained up to the last committed transaction. The ease and simplicity of creating and monitoring database mirroring will quickly make it a configuration that many people use. Adding variations to this configuration, such as enhancing data replication or offloading reporting users, adds ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
