What’s New with Database Snapshots
With SQL Server 2014, there is little new to this feature beyond what was available in SQL Server 2012. One hundred percent of the SQL code you have set up for creating and managing snapshots should still work perfectly with SQL Server 2014. No upgrade pain here. However, database mirroring is a deprecated feature in SQL Server 2014 and may not be available in a future release of SQL Server. If you are considering using database snapshots with database mirroring, you may want to plan to switch to using readable secondary replicas with AlwaysOn Availability Groups instead.
Note
The examples in this chapter are based on the AdventureWorks2012 database.
Get Microsoft SQL Server 2014 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
