Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

Denali – Day 16: Tool: Database Recovery Advisor –SSMS tool

As blogged on “Denali – Day 11: SSMS enhancement” about Features added on SSMS, now you can restore a page using SSMS, to add to it SSMS has another tool called “Recovery Adviser” where you could restore database point in time with specific timeline.

When you restore a backed up database, this requires “FULL/Bulked Logged” Recovery model(cannot recovery in “SIMPLE” recovery model). you could specify backup files, now when you want to restore on timeline to particular time. with the help of Recovery advisor tool, it will show you GUI of timeline till what time you can restore your database with all the backup files, it’s a very easy way to restore the database for any one just by moving your cursor. No knowledge of T-SQL is required.

Go to Object Explores -> Select Particular database – > Task -> Restore

On restore screen after providing backup files, if it included transaction log on it, you will get “Timeline” button activated (which will pop up “Recovery Advicer”

When you restore, at that time it will automatically take the “tail log backup”. And shows how much files and percentage has completed.

  • Take a tail-log backup before point-in-time restore.
  • This is restore task so all restore related restriction applies to it like no user connection should exist on the existing database.
  • FileStream file group backup not supported for point-in-time restore.
  • Same can be achieved using T-SQL option “WITH STOPAT“.

http://www.mssqltips.com/sqlservertip/2618/point-in-time-recovery-using-new-timeline-feature-in-sql-server-2012

SSMS Recovery point in time

http://blogs.msdn.com/b/managingsql/archive/2011/07/13/recovery-advisor-an-introduction.aspx

Also work for Split file backup/restore

http://blogs.msdn.com/b/managingsql/archive/2011/07/13/recovery-advisor-using-ssms-to-create-restore-split-backups.aspx


 


Comments

Leave a comment on the original post [thakurvinay.wordpress.com, opens in a new window]

Loading comments...