December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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, ...