Jump to content
Sign in to follow this  
Jiff Lemon

Unable to restore Database

Recommended Posts

OK, using retrospect version


Trying desperately to restore a SQL DB. I have a full restore from the first of the month, which I can restore.

Also have daily differentials of the database.


Restoring the full database isn't a problem

When i try to restore the Differentials, restrospect is asking me for full backup set from over a year ago!


What the heck is going on?


how can I tell it to use the full restore from the begining of the month?

Share this post

Link to post
Share on other sites

You should go to Reports>Databases and get properties on the database you are trying to restore. It will show you which backup sets contain your data files and what the member names are.


The Full Backup can be on Backup Set A and the Differentials can be on Backup Set B.


If you wanted all the data to be contained on Backup Set B (full and differential) then you must do a Full Database backup to Set B before attempting differentials.

Share this post

Link to post
Share on other sites

Differentials are on one set (lets call it A)

Fulls are on another (lets call it B)


However, when I try to restore the differentials, it asked for a year old set (set C) , NOT set B


I can sucessfully restore the set B full backup, but need to use the differentials to roll it forward.

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