O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Mirroring

Although failover clustering provides hardware redundancy, only a single copy of the database exists on the shared drive array. If you only needed to plan for the failure of the server, then failover clustering would be sufficient to meet your availability needs. However, the most common hardware failure, disk drives, can only be mitigated by having a second copy of the database on another machine.

Database mirroring will maintain a second copy of a database on another machine so that you are protected from both server and storage failures. Unfortunately, you can only use database mirroring with databases that do not have a filegroup enabled for FILESTREAM.

Database Mirroring Roles

There are two mandatory database mirroring roles ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required