Robert,

After verifying that you are performing log backups
with "/TRUNCate=Yes" (the default is Yes), make sure that
the log backups are succeeding by looking at the Data Protection
for SQL Log file. If they are succeeding, then here
are a few other things to look at:

Is the log backup size also growing each day?
Check the output of the log backup to find out how large they are.
Keep in mint that the physical log file itself can grow
in order to handle SQL Server operations that are occuring.
But, it will not shrink automatically. A log backup will only
back up the pieces of the log that need to be backed up...
even though the physical file itself may grow.
Have you tried shrinking the physical log file with DBCC SHRINKFILE?
Here are some other KB entries:

   http://support.microsoft.com/?kbid=873235
   http://support.microsoft.com/default.aspx?scid=kb;EN-US;272318
   http://support.microsoft.com/kb/256650/EN-US/

Thanks,

Del

----------------------------------------------------
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 10/28/2004
03:52:30 AM:

> Hi to all
>
> I am running every day at night a full Sql backup and during the day
> another log Sql backup till few days ago everything seems to work
> fine but now I remarked that the log file on my disc  is growing
andgrowing .
> My  DB recovery mode is  FULL  in the SQL enterprise Manager , I
> check the SQL gui for active and inactive restore and I saw the
> correct picture of just full backup's and the last log I run .
> But why in my disk the log file still grow ??????
>
> Any suggestions !!!!!!!
>
> My TDPsql version is 5.1.5.0 .
>
> Regards
>
> Ouzen Robert
> rouzen AT univ.haifa.ac DOT il
>