How to restore multiple incrmentals

[rvandenberg]

Hello,

Murphy's law: When your colleague is on vacation, you get to solve it.

Here is my problem:

We do a full backup every last day month, and a incremental every day.

Now I need to restore a full directory tree to a different location. The status of this data should be the 18th of the month.

I allready retored the last full backup. Now do I need to add 18 jobs to restore to get to the 18th day of the month or can I do this at once.
If yes (I can't imagine otherwise) how do I do this...

--- Please help ---

Thanks in advance

Richard

 

[JimInKS]

If you really have 18 incremental backups, ie just the files changes since the previous backup, then you will need to restore all 18 backups from oldest to newest.

In the future you may want to review your backup plan. You should do a full backup more often than once a month, probably once a week. And I would only use incremental backups if you have a lot of activity on the server. I like to use a differential backup, which will backup all files since the last full backup. This way to do a complete restore it just requires the last full backup followed by the last differential backup and you are done.

Also, with incremental backup if you have a bad tape you have lost those files. With differential backup you would only loose files if the newest tape was bad.

 

[rvandenberg]

Hello,

Thanks JimInKS for your response I will keep that in mind, but that was not my question.

The question is:
IF possible, How to restore 18 days of incremental backups in 1 job.

Please let me know

Thanks in advance

Richard

 

[JimInKS]

If all backups are on one tape then you should be able to use "Restore by Session".

Find the Tape you are restoring from on the "Source" tab of Restore by Session. Each days backup should be a "session" on that tape. Select all the sessions you want to restore.
Complete the remainder of the restore process.

Hope this helps,
Jim