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
You want to use a perspective in an mdx query. How do you select the perspective?
What is multi-statement table-value user-defined function?
Explain syntax for disabling triggers?
Explain tables in SQL Azure?
What do you mean by 'normalization'?
What is a trigger and its types?
Who is the owner of a schema in ms sql server?
What is SQL Server?
What are pages and extents? : SQL Server Architecture
How do I find the sql server version?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
What is data set in report?
what are the disadvantages of cursors? : Sql server database administration
If no size is defined while creating the database, what size will the database have?
Write query to return all rows sql?
