Chapter 13 Administering and Managing Database Mirroring

This chapter takes a systematic look at database mirroring, one of the four high-availability alternatives offered with SQL Server 2008. Database mirroring was probably one of the most anticipated features of SQL Server 2005. Unfortunately, it wasn’t ready for prime time and was actually pulled and not officially supported when Microsoft shipped SQL Server 2005, creating slight disappointment. It wasn’t until the release of SQL Server 2005 Service Pack 1 that database mirroring was officially supported in production environments.

Database mirroring offers increased database availability and database protection by providing and maintaining a hot standby database on another instance of ...

Get Microsoft 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.