SQL Server 2005 Database Mirroring

Databases hold the vital information that users need to do their jobs and that applications need to communicate with services and processes. So in many organizations, you need to ensure that your databases are up and running 24x7. These days, with database system design getting more and more complex, you must consider database availability from the early design stages. This is where Microsoft high availability technologies such as clustering, transaction log shipping, replication, and database mirroring come into play. This whitepaper introduces you to database mirroring, a new feature in SQL Server 2005 that transfers transaction log records directly from a principal server to a mirrored standby server and that lets you quickly fail over to the standby server. In this paper, you’ll learn:

• The roles of the participants and how database mirroring works

• How to set up, configure, and monitor database mirroring

• How database mirroring compares with other high availability