What is database mirroring in SQL Server and how can it benefit your environment? SQL Server database administrator Eric Johnson starts by outlining the three roles involved
Requires Free Membership to View

Podcast |
- Download the podcast: Database mirroring in SQL Server 2005
Podcast highlights - Total run time: 11:33
- (0.50) What is database mirroring?
- (2.04) What types of mirroring solutions are available and which is most appropriate for High
Availability?
- (6.07) How do you configure clients to work with a mirroring solution?
- (9.24) Can you read the data stored in the mirror database?
-
Related tips and guides: - Database
mirroring setup in SQL Server 2005: SQL Server 2005 database mirroring allows you to
automatically mirror database contents. Learn how it works and how to get it up and running with
Management Studio.
- Q&A:
Database mirroring in SQL Server 2005 and its witness: Database mirroring in SQL Server
2005 will increase your system's availability by allowing a quick and automatic failover. Learn
more about the role of the witness.
- SQL
Server 2005 backup and recovery: 5 handy tips: Backup and recovery with SQL Server 2005
include several new features worthy of your attention. Here are five tips to help you take full
advantage of these enhancements
ABOUT THE AUTHOR: Eric Johnson (MCSE, MCITP: Database Administrator, MCSD) is co-founder of Consortio Services and the primary Database Technologies Consultant. He has delivered numerous SQL Server training classes and webcasts as well as presentations at national technology conferences. Eric has presented at TechMentor on SQL Server 2005 Replication, Reporting Services, and Integration Services. He is president of the Colorado Springs SQL Server Users Group. You can see Eric at the Highly Available SQL Solutions seminar in Denver, CO on July 26th and 27th. Learn rock solid solutions with in depth coverage of clustering, mirroring, log shipping, replication and disaster recovery.
This was first published in June 2007