November 5, 2008 at 2:58 pm
Hi
We are facing an issue with the size of TL for one of our database whose recovery model is FULL. We are tL backups every 2 hour but log file size is growing heavily every 20-25 minutes or so.
Our data file size is 17 GB and log file grows upto 100 GB in less than 20 minutes. Can anyone suggest what could be the cause for this and what could be the resolution?
Does increasing the frequency of TL backups is the only way to solve this or is there any setting we can chnage in database?
Any valuable suggestion is much appreciated.
November 6, 2008 at 7:36 am
100 G in 20 minutes ?? You must have some huge transactions taking place. Did someone accidentally schedule index rebuilds to run all day long ?
November 6, 2008 at 2:37 pm
You need a trace to see what activity is taking place. The log grows when any transactions are running, including index rebuilds, DBCC, etc. Something is happening. Check jobs as well.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply