Friday, July 13, 2012

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery - SQLServerCentral

SQL Server 2012 Database Recovery Advisor: Simplified Point in Time Recovery - SQLServerCentral


By Jonathan Kehayias, 2012/07/13
The aim of the new Database Recovery Advisor in SQL Server 2012 is to simplify the task of piecing together a recovery sequence from multiple backup files, comprising full, differential, and log backups. My previous article, Simplified Restores with SQL Server 2012 Recovery Advisor, explained how to use the tool to fully recover a database from a multiple backup files that originated from multiple servers. In this article, I'll demonstrate how the tool also makes it easier to plan for, and perform, a point in time recovery from a series of backups, in order to recover data that may have been lost due to an application bug, or user error.

No comments: