Chapter 19. 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 2005. Database mirroring is 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 SQL ...

Get Microsoft now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.