Post reply

transaction log file full

  • September 13, 2004 at 3:52 am

    #108600

    Hi

    I'm getting "transactio log file full" error on database

    My log file size is 1 GB ad % utilization is 63%

    Log file is incremented @ 10%

    Could anyone pls tell me what is this and how to resolve the problem

    If I chang the % amt from 10 to 25 ..do I need to restart the server to make it effective

    Thanks

    Ritesh

  • September 13, 2004 at 6:31 am

    #522714

    this message occurs when sqlserver gets a timeout when trying to extend a file. In this case it's the logfile.

    The is no need to restart when altering the increment size for a file.

     

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me

  • September 14, 2004 at 2:57 am

    #522893

    Hi,

    Backup the transaction log and truncate it.You'll save some place onto your server and all pending active transaction will be validated and all inactive will be truncated.

     

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

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