Answer Posted / naren
The CHECKPOINT statement saves time in a subsequent
recovery by creating a point at which all modifications to
data and log pages are guaranteed to have been written to
disk.
Checkpoints also occur:
When a database option is changed with ALTER DATABASE. A
checkpoint is executed in the database in which the option
is changed.
When a server is stopped, a checkpoint is executed in each
database on the server. These methods of stopping Microsoft
SQL Server 2000 checkpoint each database
| Is This Answer Correct ? | 4 Yes | 8 No |
Post New Answer View All Answers
Are null values the same as that of zero or a blank space?
Why use “in” clause in sql server?
What is isolation levels?
Write a SQL query to make a column as unique?
in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration
Do you know what are acid properties?
What happens if null values are involved in comparison operations?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is 2nf normalization?
What according to you is the difference between mysql and sql server performance?
How to find out the list schema name and table name for the database?
What are the system database in sql server 2008?
What is a trigger in sql server?
What method is used by the Command classes to execute SQL statements that return single values?
What is the meaning of sql server?
