checkpoint

Description

Writes all dirty pages (pages that have been updated since they were last written) to the database device.

Syntax

checkpoint [all | [dbname[, dbname, dbname, ........]]

Examples

Example 1

Writes all dirty pages in the current database to the database device, regardless of the system checkpoint schedule:

checkpoint

Usage


Automatic checkpoints

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

checkpoint permission defaults to the database owner. It cannot be transferred.

See also

System procedures sp_configure, sp_dboption