Empty log file

Hello!
Someone said to me that only a complete tape backup will empty the log file.
THe log is backed up but the file is not empty.
I thought that a complete backup to disk or tape will empty the log file.
Do anyone know the answer?
Regards
Stefan N?smanI'm not sure what you mean by "complete backup". A database backup does not
empty the log file, nor does a differential, file or filegroup backup. The
only backup type that actually empties a log file is a transaction log
backup. If you don't want to do transaction log backups (for some strange
reason), then just put the database in simple recovery mode.
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"Stefan Nsman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan Nsman|||Stefan
Backup Log file removes inactivate portion of log file ( commited
transaction written to the disk)
"Stefan N?sman" <anonymous@.discussions.microsoft.com> wrote in message
news:7F9F50EB-4463-48A8-9150-D6C2FCDFED1E@.microsoft.com...
> Hello!
> Someone said to me that only a complete tape backup will empty the log
file. THe log is backed up but the file is not empty.
> I thought that a complete backup to disk or tape will empty the log file.
> Do anyone know the answer?
> Regards
> Stefan N?sman