Saturday, February 25, 2012

No truncate of transaction log during database backup

Hello,
A transaction log on one of my sql 2000 server is growing
bigger and bigger. During the backup with backupexec 9.1
the log isn't truncated. I use the option full in the
option tab of the dbase.
cheers!
KeesFull backups do not truncate inactive log entries. Transaction log backups
in full recovery model will remove inactive portions. Removing inactive
entries will not shrink the log file. There is a separate command for that.
I suggest reading the entire backup and recovery section in BOL (Books
On-Line) as your choice of recovery models has several implications for
database maintenance.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Kees" <anonymous@.discussions.microsoft.com> wrote in message
news:000c01c3dc64$0821f7b0$a001280a@.phx.gbl...
quote:

> Hello,
> A transaction log on one of my sql 2000 server is growing
> bigger and bigger. During the backup with backupexec 9.1
> the log isn't truncated. I use the option full in the
> option tab of the dbase.
> cheers!
> Kees

No comments:

Post a Comment