O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

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

Another failover option with SQL Server is database mirroring. However, Microsoft has announced that database mirroring will be deprecated in future SQL Server releases and advises not to plan much more with database mirroring but to use AlwaysOn Availability Groups or log shipping instead. For folks who aren’t planning upgrades to SQL Server 2014 very soon, database mirroring is still very viable and extremely stable for both HA and distributed workload needs. We’d say that you are fine for a few years yet. As mentioned earlier, the AlwaysOn capabilities actually utilize much of the technology components that are in database mirroring. Database mirroring has effectively paved the way for AlwaysOn Availability Groups.

Originally, ...

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