Jump to content
Sign in to follow this  
jnarcn

Restore procedures

Recommended Posts

We are using Retrospect 7.6 and SQL Server 2005 and have a nightly full backup to tape and hourly transaction log backups to a local drive on the SQL server which are then also copied to another machine. In testing, I can do a restore fine of the full backup from tape, but I dont see how to restore the full and then apply the log backups up to a point in time. I've done it many times directly in SQL Server but this is the first time I've used Retrospect. Can you tell me what the procedure is to restore to a point in time? Also, with the log backups on another machine, do I need to copy them back to the original backup location? Thanks,

 

John

 

Share this post


Link to post
Share on other sites

I believe you can restore by selecting the most recent log backup and Retrospect will locate all the prior backup parts needed to restore the DB.

Share this post


Link to post
Share on other sites

I thought that also, but when I tried a restore by picking a transaction log from the list of Database Snapshots, the Restore Database button was still disabled. The option to restore any necessary differentials, etc was checked. I'm sure I'm just missing something.

 

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×