Hi 

Thanks to all the people who respond to my question especially to Del Hoobler 
for his very good articles .

Regards Robert

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Del Hoobler
Sent: Thursday, October 28, 2004 2:31 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Sql log behavior

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
>