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
Regard
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=djq&as_ugroup=microsoft.public.sqlserver
"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|||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