Make sure truncate is on
An other possible solution is to set "Log Est % Diff" to a higher value in the 
GUI.

Jeroen

-----Original Message-----
From: Robert Ouzen [mailto:rouzen AT UNIV.HAIFA.AC DOT IL]
Sent: donderdag 28 oktober 2004 9:53
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Sql log behavior


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 and growing .
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