November 10, 2004 at 11:03 am
Every night the tlog grows to over 1.5 gig. I have to shrink the tlog file daily. Here is my schedule:
Tlog @ 10:00 PM
Integ Check @ 10:50 PM
Optimization @ 11:00 PM
Full db backup 11:30 PM
TLog @12:00 AM --- This log grows from approx 500mb to 1.5gb
No bulk data jobs are scheduled and there are no users on the system.
The db is set to Full Recovery Mode which I do believe may have something to do with this large tlog but I would like to know exactly why. Point in time recovery is essential. I have read thru a few posts that were similar but have not read a definitive answer. "Thanks" to all who may respond.
November 10, 2004 at 11:56 am
your optimization job includes reindexing or indexdefrags those are logged opperations and will cause the log to grow like it is.
Wes
November 10, 2004 at 10:14 pm
Probably reindexing. We have a DB that grows the log from 10MB to ~70MB when we perform a weekly reindex on 300,000 records in an DB optimisation job.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply