Geek Answers Handbook

SQL Server Checkpoints

can anyone explain when SQL Server issues a breakpoint?

+7
sql-server checkpoint
source share
1 answer

from: http://msdn.microsoft.com/en-us/library/ms188748.asp

Events that indicate breakpoints
Before backing up the database, the Database Engine automatically performs a checkpoint so that all changes to the database pages are backed up. In addition, control points occur automatically when any of the following conditions occurs:

  • The active part of the log exceeds the size that could be restored during the time specified in the recovery interval of the server configuration.
  • The log is 70% full, and the database is in logarithm mode. The database is in log pruning mode when both of these conditions are TRUE: the database uses Simple recovery models, and after the last BACKUP DATABASE statement that refers to the database is executed, one of the following events occurs:
  • Minimally registered operation - performed in the database, such as operations with minimal registration of bulk copies or minimally registered WRITETEXT
    performed. ALTER
    The DATABASE statement is executed, which adds or deletes a file to the database.

In addition, server shutdown issues a breakpoint in each database on the server. The following SQL Server shutdown methods perform breakpoints for each database:

Using SQL Server Configuration Manager. Using SQL Server Management Studio. Using the SHUTDOWN statement.

+12
source share

More articles:


All Articles