Post reply

log file full

  • November 26, 2003 at 9:06 am

    #81565

    i have got my recovery mode as "simple"

    but daily i got an error of log file full

    plz suggest despite of simple mode why the log file fulls daily

  • November 26, 2003 at 4:03 pm

    #483838

    First, Set the log file to auto growth.

    Try to see whether there are open transactions using 'dbcc opentran', if they are, you need to find out why they are still in active. Try to complete the transactions and the log will be free of spaces.

  • November 27, 2003 at 5:18 am

    #483898

    no transaction is open and autogrowth is also enabled but i dont know what the problem plz suggest

  • November 27, 2003 at 7:11 am

    #483923

    DBCC SQLPERF(LOGSPACE) will tell you how full the log file is.

    Run "backup log yourdbname with truncate_only" to see whether the usage decreases.

  • November 27, 2003 at 10:44 am

    #483935

    The same thing i do but i want permanent remedy plz

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

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