Chapter 34. Using database mirroring to become a superhero!

 

Glenn Berry

This chapter covers how to use database mirroring not only to increase availability in the traditional sense, but also for less common situations that are not typically mentioned in the SQL Server documentation or literature. One example is using database mirroring to seamlessly upgrade from SQL Server 2005 to SQL Server 2008 with a 10–15-second outage. Another example is using database mirroring to move multiple terabytes of data from one storage system to another with a 10–15-second outage. This chapter reveals these secret techniques.

Why should I use database mirroring?

SQL Server 2005 introduced database mirroring, and SQL Server 2008 enhanced it. Back in the pre-SQL Server 2005 days, you had several choices for high availability solutions with SQL Server, including failover clustering, log shipping, and replication. In many situations, database mirroring offers key advantages over all older technologies. It is simple to set up and administer, it offers fast automatic failover, it works at the database level (rather than at the instance or table level), and it can be used with commodity-level hardware.

How does database mirroring work?

How do you set up database mirroring?

How do you prepare the mirror?

Using database mirroring for routine maintenance

Using database mirroring to upgrade to SQL Server 2008

Using database mirroring to move data seamlessly

Summary

About the author