Re: Sql log behavior

2004-10-28 Thread Robert Ouzen
PROTECTED] 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

Re: Sql log behavior

2004-10-28 Thread Del Hoobler
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

Re: Sql log behavior

2004-10-28 Thread Hooft, Jeroen
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:[EMAIL PROTECTED] Sent: donderdag 28 oktober 2004 9:53 To: [EMAIL PROTECTED] Subject: Sql log behavior Hi to

Sql log behavior

2004-10-28 Thread Robert Ouzen
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