Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    20

    Unanswered: Checkpoint not being issued

    Hi,

    Has anybody encountered this situation before? DB on SQL Server 2000 SP4 with trunc log on chkpt option turned on. Checkpoint trace flags were turned on but noticing no checkpoints are being done on one specific DB resulting into growing transaction log. No open transactions.

    Any ideas?

    Thanks.

  2. #2
    Join Date
    Jun 2005
    Posts
    79
    What traceflags are you using, and why?
    Paul Randal
    Dev Lead, Microsoft SQL Server Storage Engine

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •