Time when a checkpoint appears

Time when a checkpoint appears (1) explicitly execute the checkpoint statement. Check points appear in the current database for connection (2) Minimum log record operations are performed in the database, for example, large-capacity replication is performed in a database using the large-capacity log recovery mode (3) you have used ALTERDATABASE to add or delete database files (4) Restart S

Time when a checkpoint appears (1) explicitly execute the checkpoint statement. Check points appear in the current database for connection (2) Minimum log record operations are performed in the database, for example, large-capacity replication is performed in a database using the large-capacity log recovery mode (3) you have used alter database to add or delete DATABASE files (4) Restart S

Time when a checkpoint appears

(1) explicitly execute the checkpoint statement. Check points appear in the current database used for connection

(2) The minimum logging operation is performed in the database. For example, the large-capacity replication operation is performed in a database using the large-capacity log recovery mode.

(3) You have used alter database to add or delete DATABASE files.

(4) restart the SQLSERVER Service

(5) automatic checkpoint

(6) back up the database

(7) set the option to disable database activity, for example, AUTO_CLOSE is set to ON, Hong Kong space, and the connection of the last user of the database is closed, Hong Kong virtual host, website space, or restart the instance.

Database option change