Re: Sql log behavior
2004-10-28 04:17:44
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
|
|
|