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
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
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
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