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 in Database Backup and Restore
SQL Server 2012 offers a number of new features in this release. These features are centered on improved usability in the SQL Server Management Studio as well as support for the AlwaysOn Availability Groups. The biggest new usability improvement in SSMS comes in the form of the Database Recovery Advisor. This tool is launched from the Restore Database window and is intended to simplify the restore process. It does this by displaying a visual timeline that outlines the database backups that are available for restore. The visual timeline differentiates between the types of backups that are available, such as full, differential, and transaction log backups. It also allows a user to restore to a point in ...