Post reply

Transaction Log Full in Simple Recovery Model

  • March 11, 2007 at 10:34 am

    #177118

    Hello all,

    I am having a problem with a couple of DBs where the transaction logs get full even thought the recovery model is set to Simple. I have the log set to Automatic growth but still I keep getting alerts about the log getting full.

    Has anybody seen this before?

    Thanks in advance

    M

  • March 11, 2007 at 1:27 pm

    #694280

    Reason could be big transactions... check it out if you have any large sinle transaction...

    ex: If you have table with 10 mil rows and running delete against it instead of truncate table may cuase the log full even the db is simple recovery model because it is single transactions....

     

    MohammedU
    Microsoft SQL Server MVP

  • March 11, 2007 at 10:23 pm

    #694294

    Mohammed is right. Also, check with the free disk space. The free disk space ratio should match with DB size. For all the big transactions, free space is required for the temp folder.

    Amit

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

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