Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Database Mirroring and Snapshots
Database mirroring has seen a very big uptake on its usage by companies around the world, based on its ease of configuration and its great high availability benefits. Even with this feature’s popularity high, Microsoft has announced that it will be deprecated in the next couple of years. If this is anything like when they announced that log shipping would be deprecated back in 2008, it might take a while for this to happen. (Log shipping has not disappeared from our SQL Toolkit yet, and it is now 2013!) So, some caution of using database mirroring now should be taken, but it is a very good DR option for those who need to get this done fast. In either a high-availability mode (synchronous) or performance mode (asynchronous), ...
Become 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,
and much more.
Read now
Unlock full access