Post reply

Unexpected growth in TL size

  • November 5, 2008 at 2:58 pm

    #214969

    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

    #894858

    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

    #895232

    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.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • November 6, 2008 at 11:49 pm

    #895326

    For time being, while tracing the source, you may change recovery model to simple. This will let you out of this problem until you trace the reason.

    DBDigger Microsoft Data Platform Consultancy.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply