O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required