Posted by Russell Fields on 07/12/07 17:51

Brian,

If you want to save a little bit of backup space, run the 6pm log backup
just before the full backup. If you run it after, you will have backed up
the 12pm-6pm log activities twice.

Do NOT truncate the log ever, if you want to be able to restore the full
backup and then apply the logs to the full backup. If you were to backup
the database, then truncate the 6pm logs, the 12am, 6am, 12pm log backups
are all useless, since there is an unbridgeable transaction log gap between
the full backup and the first log.

RLF

"Brian D" <bdaltilio@yahoo.com> wrote in message
news:1184261915.544240.106090@d55g2000hsg.googlegroups.com...
> Erland,
>
> We do a full backup daily at 6pm. If we do a trans log backup 4 times
> a day at 12 am, 6am, 12pm and 6pm, should the 6pm trans log be
> immediately before or after the full backup or can we just skip the
> 6pm one all together? If I skip the 6pm trans log backup should I
> truncate the log immediately after the full backup?
>
> Brian
>

• Next in forum: Re: Help convert an Oracle select on indexes to MSSQL...?
• Prev in forum: Re: Does a Full Backup include transaction logs
• Thread view: Re: Does a Full Backup include transaction logs

[Reply to this message]