|
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)
|
|
| Ricky Artigas 2002-11-20, 8:23 pm |
| You can't. The Tuesday log(s) doesn't have the
transactions between monday full backup and tuesday full
backup anymore.
>-----Original Message-----
>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
>
>
>
>
>.
>
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| Ricky,
BACKUP DATABASE doesn't truncate the log. I.e., the backup/restore schedule should work.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Ricky Artigas" <rya@easycall.com.ph> wrote in message
news:cc0501c29101$f57f9850$8df
82ecf@TK2MSFTNGXA02...
> You can't. The Tuesday log(s) doesn't have the
> transactions between monday full backup and tuesday full
> backup anymore.
>
> >-----Original Message-----
> >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
> >
> >
> >
> >
> >.
> >
|
|
|
|
|