Post reply

Log File not truncating at checkpoint in simple recovery

  • February 6, 2009 at 5:17 pm

    #218363

    I was on a client's server when i noticed that the log file for one of the databases had been autogrowing. The database is in simple recovery, there is no replication happening on the server, and there are no open transactions. I've seen in perfmon that the checkpoints are occurring but nothing is being truncated at that time, when I manually do a checkpoint I start seeing activity on the Log Truncations counter.

    So I've created an Agent job to do a manual checkpoint every 10 min which seems to have "Band-Aided" the situation.

    Any suggestions?

    TIA

    -Steven

  • February 6, 2009 at 5:38 pm

    #939872

    what is the recovery interval set for the database?

    quoting from http://msdn.microsoft.com/en-us/library/aa174542(SQL.80).aspx

    SQL Server 2000 always generates automatic checkpoints. The interval between automatic checkpoints is based on the number of records in the log, not time.

    There might be some query running which is increasing the log file size drastically.


    Pradeep Singh

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

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