Home > Archive > microsoft.public.sqlserver.server > November 2002 > Question about Transaction log (backup-restore)





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Question about Transaction log (backup-restore)
Danny Presse

2002-11-20, 5:23 pm

Hi,

Lets see our Backup Plan

Full Backup at 20:00 Monday (on disk)
Full Backup at 01:00 Tuesday (on Tape with backupexec)
Backup FILE at 03:00 Tuesday (on Tape with backupexec)
Backup LOG at 09:45 Tuesday (on disk)
Backup LOG at 11:45 Tusday (on disk)
Backup LOG at 13:45 Tuesday (on disk)
Backup LOG at 15:45 Tuesday (on disk)

Tuesday, if I want to RESTORE my DB, can I do that in this order ????
Restore Full Backup from 20:00 Monday (on disk)
Restore LOG from 09:45 Tuesday (on disk)
Restore LOG from 11:45 Tusday (on disk)
Restore LOG from 13:45 Tuesday (on disk)
Restore LOG from 15:45 Tuesday (on disk)

Thank you

Danny




Sponsored Links





Free Braindumps | MCSE braindumps software forum

Copyright 2003 - 2008 examnotes.net