Overlapping backups - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Overlapping backups

Author

Topic

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-10-17 : 17:11:11

I'm backing up a database on the following schedule:

FULL 21:00 Daily
DIFF 22:00 - 20:00 Hourly
LOG 21:15 - 20:45 Every 15 Minutes

The problem is that how can I guarantee that at 22:00 for example
my DIFF runs after my log backup so that when I restore I can do the following

Restore last full backup
Restore last diff
Restore every log after last diff.

One way I've thought about doing it was to have 3 separate log backup jobs running hourly

1 21:15 - 20:15 Hourly
2 21:30 - 20:30 Hourly
3 21:45 - 20:45 Hourly

Is there any other way to solve this problem?

Edited by - ValterBorges on 10/18/2002 13:46:20

JamesH
Posting Yak Master

149 Posts

Posted - 2002-10-18 : 08:32:34

I would suggest before you restore your database that you do a RESTORE HEADERONLY from your backup to determine what and when was backed up. If you look in the backuptype column from the results you can see what each file within the backup is:

Backup type:
1 = Database
2 = Transaction Log
4 = File
5 = Differential Database
6 = Differential File

You can then determine the times by BackupStartDate. If you want to guarantee that it runs after your log backup then I would set another schedule for your log backup to not run at or around 22:00. But in the event of a restore it's always a good idea to see what's in your backup before you try to restore.

JamesH.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources