Differential Restores

[dellboy]

I'm being lazy but thought someone might be able to help me out before I go off and test/search out a solution.

I have re-engineered my backups to a full backup on a Friday and then differentials Mon-Thurs.

Example:
Today is Wednesday week2, I ran the full backup last friday week1 and then want to restore a file deleted the following Tuesday week2. Do I insert week1 full backup, restore file, insert Tuesday week2 and restore file and then all is hunky dory and upto date?

Hope this makes some sense and I am sure with a little reading and playing I will suss it but if anyone can offer any guidance I would be greatful.

Cheers

 

[jcassidy]

if the file was edited between Friday and Tuesday, it will be on Tuesday's tape. You only need to restore it from there. If the file did not change in that time period, the file will only exist on Friday's tape.

 

[bfralia]

If you do the full + differential, you'll have to set up a job to run them at the same time. You can't run the differential by itself.

 

[blonde]

If you are doing a restore of a file. It is like jcassidy said. If the file was worked on after the full was done, then you will find the file on the differential tape. and you can restore from that. But if it has not been worked on, go to the full backup and restore from that.
I start my week 1, week2, week3, etc. with a full backup and then do differentials the rest of the week. blonde

 

[dellboy]

Blonde, so what you are saying is that if a file is modified, for instance the content of the document is changed then the whole document will be backed up when running a differential. Only documents that have had modifications made are backed up and then the whole document is backed up, seems to make sense.
This would mean that in a disaster recovery situation you would restore the full backup and then restore the differential selecting to overwrite exisiting files if more recent.

Cheers for everyones input