Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    Posts
    55

    Unanswered: when will the Checkpoint happens?

    when will the Checkpoint happens?

    Full database backup?
    Transaction Log backup?

    How to setup truncate log on checkpoint?



    Thanks

    Guyang

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    At various levels CHECKPOINT occurs :

    - any changes made to database with ALTER DATABASE for any option updation
    - SQL services are refreshed
    - active portion of the log exceeds the size that the server could recover in the amount of time specified in the recovery interval server configuration option.
    -if the database is in log truncate mode and the log becomes 70 percent full
    - If the database model is set to SIMPLE and same as 'Trunc.log at chkpt.' in verson 7.
    - when BACKUP LOG statement is issued.

    Choose the properties of the database and goto Options.

    Refer to books online for more information.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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