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
Can the “if update (colname)” statement be used in a delete trigger?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is SQL Azure Fabric?
what are user defined datatypes? : Sql server database administration
What does dml stand for?
Can group by be used without aggregate functions?
SQL Server Architecture ?
What are the types of ssrs?
How to select an exiting database using mssql_select_db()?
What is usually the first word in a sql query?
what are constraints? : Sql server database administration
What does ss stand for sexually?
How to modify existing triggers using "alter trigger"?
What do you think of this implementation? Can this be implemented better?
What is difference between line feed ( ) and carriage return ( )?