Post reply

Transaction log status

  • January 9, 2009 at 8:11 am

    #383710

    I'm trying to find the equilivant of this query but for sql 2000

    SELECT log_reuse_wait_desc FROM sys.databases

    I'm trying to understand the pattern of growth of my transaction log.

    Any help or advice would be greatly appreciated!

  • January 9, 2009 at 8:24 am

    #924229

    There's no equivalent on SQL 2000.

    On SQL 2000, check to make sure the log backups are running and check that there are no old open transactions or old unreplicated transactions (DBCC OPENTRAN)

    Those are pretty much the three main reasons for logs not been reused on SQL 2000.

    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

  • January 9, 2009 at 8:28 am

    #924237

    Thank you very much!

    At least I can stop frantically searching google ...

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

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