Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are sub reports and how to create them?
What is the return type of executeupdate ()?
What is the security principal at the database level that represents your session?
What is the openxml statement in sql server?
Explain raiserror in sql server?
What are “unrepeatable reads”?
What is thr feature of change data capture?
Explain encryption of entire databases without the need for application changes in sql server 2008?
In what version of sql server were synonyms released?
How to Check if table exists in sql server?
What is a deadlock and what is a live lock?
Why we need sql server?
Tell me what is a linked server?
Difference between report and query parameter.
Can sql servers link to other servers?
