O'Reilly logo

SQL Server MVP Deep Dives by Greg Low, Paul Randal, Kimberly Tripp, Adam Machanic, Kalen Delaney, Paul Nielsen

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

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 ...

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