Post reply

Transaction Log Full error 9002.

  • June 19, 2012 at 2:41 am

    #271438

    Hi I had a transaction log full message yesterday (Error: 9002, Severity: 17, State: 3.) and was not able to get info on why the error occured. Does anyone have a list of the error states and their meaning for 9002 messages?

    SQL server 2008R2 ENT

    Thanks in advance.

  • June 19, 2012 at 3:00 am

    #1502632

    Please read through this: http://www.sqlservercentral.com/articles/Transaction+Log/72488/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 19, 2012 at 3:45 am

    #1502661

    Hi Gail, thanks for the reply. I had seen your informative article previously. In this case the log filled overnight and had cleared before anyone was able to get onto the system to investigate further so no chance to check for an open tran or check the log_reuse_wait_desc state in sys.databases.

    Is the state in the 9002 error (Error: 9002, Severity: 17, State: 3.) actually the same as the state of the log_reuse_wait_desc in sysdatabases? ie In this case the log filled due to an Active backup or restore?

  • June 19, 2012 at 4:00 am

    #1502673

    Nope, sorry. You'll have to monitor and see if it happens again

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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