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 Unleashed
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,
Start your free trial
What’s New with Database Snapshots
With SQL Server 2012, there is little new to this feature beyond what was available in SQL Server 2008. One hundred percent of the SQL code you have set up for creating and managing snapshots should still work perfectly with SQL Server 2012. No upgrade pain here. However, database mirroring is a deprecated feature in SQL Server 2012 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 them with AlwaysOn Availability Groups instead.
Note
The examples in this chapter are based on AdventureWorks2012 database.