Post reply

transaction log filled

  • September 14, 2008 at 7:39 pm

    #193602

    Hi Folks,

    My transaction log filled on a database. When I checked the database it was in single user mode. The log is set to autogrowth. I was just wondering if the database being in single user mode is an effect of the trans logs filling up (even if the log is set to autogrowth).

    I have backed up the log and put the database backup in multi user.

  • September 15, 2008 at 1:01 am

    #871602

    Did you check the open transactions?

  • September 15, 2008 at 1:46 am

    #871612

    If the DB is in full recovery, then the log backups probably won't be able to run due to the single user mode.

    If the DB is in simple recovery, then check for replication and long-running transactions

    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 3 posts - 1 through 2 (of 2 total)

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