Post reply

Transaction log filling up

  • September 30, 2005 at 7:01 am

    #111083

    Hi gurus,

    We are running some scripts to clear some history out of the DB, but it keeps filling the trans log up. Is there anything else that can be done to stop this happening or to minimize its impact

    Thanks for your reply

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • September 30, 2005 at 7:05 am

    #594308

    I am a newbi to sql, but wouldn't a backup of the transaction log "with no_truncate" help in your situation?  Remember I am a newbi, so please look up that option before using it

  • September 30, 2005 at 9:13 am

    #594354

    Hai,

    I have added one more log file to the database , asked the application team to make transaction as short as possible so that the log is truncated as soon as the transaction is committed(simple recovery model) and shrunk the file to an acceptable size using DBCC SHRINKFILE option. That worked for me

     

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

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

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