Database Recovery Advisor feature of SQL Server 2012
SQL Server 2012 introduces Database Recovery Advisor that provides significant user experience improvements to the ways DBAs can restore databases with SQL Server Management Studio. As we know, SQL Server provides a variety of backup types, so creating the proper recovery sequence for each point in time can be tricky at times. This is where Database Recovery Advisor is useful, because it makes the database restoration process more agile by helping the customers to create more predictable and optimal recovery sequence.
The Database Recovery Advisor provides a visual timeline from the backup history of the database and then presents the available points in time at which the user can restore the database, algorithms to streamline the identification of the appropriate sets of backup media to restore the database back to a specific point in time. By default, the Database Recovery Advisor tries to restore the database from the last backup taken, but as I said earlier, we can use visual timeline feature to restore the database to an earlier point than last full backup.
The Database Recovery Advisor is available via Restore Database dialog box, which you can launch as follow:
1) Right-click database which you want to restore and then navigate to “Databases…” and then click on “Databases…” to launch Restore Database dialog box.
2) In Restore Database dialog box, click “TimeLine…” button to launch Database Recovery Advisor visual timeline.
3) Choose “Specific date and time” option and then use the arrow to specify the restore point. After choosing the appropriate restore restore point, click OK button to return to Database Restore dialog box (see below):
4) Click OK button in Database Restore dialog box to start the database restore (see below):
Conclusion
The Database Recovery Advisor is a great feature of SQL Server 2012, allowing users with a visual timeline of database restore points from backup history. As we have seen in this post, this feature is easy to use and with the help of this feature we can easily perform point-in-time database restore.
It’s an awesome feature to be honest. Nice post.
Reblogged this on The SQL Pro and commented:
Very nice post about one of the new features of SQL 2012 – the GUI for point in time recovery.
I am using SQL 2012 from past 2 months but was not aware of this feature. Thanks for sharing. I will surely try my hands at it.
Thanks for sharing this useful feature. It will help to solve the data loss problems. Recently, I was also experiencing corruption issues in my sql database and fixed with the help of a third party tool: http://www.serversdatarecovery.com/sqldatabase.html
Thanks
Smith
I used SQL Server 2012 Database Recovery Advisor feature & found some difficulty. Here is full scenario:
I select a point-in-time restore option from which backup is available. After that it reported following error message:
“Unable to create restore plan due to break in the LSN chain.”
I am unable to find out the exact cause of the error. Please help me..
Now a Days many company offer SQL Database Recovery software to repair all types of sql server corruption. One such utility is here.
http://www.recoverydeletedfiles.com/sql-database-recovery-software.html
FREE to TRY
Thanks