Post reply

Log file increasing

  • September 21, 2010 at 5:18 am

    #227034

    HI,

    I have a database whose log file has increased to 70 GB. Took the log backup but still its not clearing up. Tried checking using DBCC log where status=2. A lot of records after status=2 are there but still not cleared after log backup. Can somebody pls advice on this

  • September 21, 2010 at 5:35 am

    #1224694

    What's the value of log_reuse_wait_desc in sys.databases for this database?

    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

  • September 21, 2010 at 5:40 am

    #1224698

    It is specified as NOTHING in sys.databases.

  • September 21, 2010 at 6:33 am

    #1224738

    Nothing means that the log is being correctly reused. Maybe whatever caused the growth has gone away.

    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