Post reply

Transaction Log fillingup while one of the Aggregation job is running

  • January 28, 2008 at 9:02 am

    #181270

    we have a scheduled job runs everyday for the duration 2hr 30 min. it does aggregations in a database. this database recovery model is simple but still it fills transaction log to 30GB. as far as i know we can't truncate transaction log while the aggregation transaction is active. any one have any idea how to avoid growing transaction file that big?

    thanks

  • January 28, 2008 at 9:26 am

    #772502

    Y, it sounds like you're doing a ton of stuff in a single transaction. Simple mode won't help you in that case because it's a single trans. So it has no choice but to fill up the log. So your choices are to get more log space, or break up your ops into smaller transactions so simple mode can do its job and truncate the log as needed to keep the size down.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • January 28, 2008 at 9:48 am

    #772524

    thanks crever for your answer.

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

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