question

yuvarajujogi avatar image
yuvarajujogi asked

What are check points and save points in Sql Server? What is the difference b/n them?

What are check points and save points in Sql Server? What is the difference between them?
sql servercheckpoint
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Usman Butt avatar image
Usman Butt answered
Well, I guess you should be able to get detailed information from BOL. But the difference seems to be quite big. CHECKPOINT forces all dirty pages for the current database and transaction log information to be written to disk. Dirty pages are data or log pages modified after entered into the buffer cache, but the modifications have not yet been written to disk. Whereas, SAVEPOINT mark a point in a transaction to which you may wish to rollback. When you rollback to a savepoint, all of the database updates performed after that savepoint are reversed. Updates that happened after the transaction started but before the savepoint was declared are not affected. You can create multiple savepoints within a single transaction and roll them back individually.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
+1 the 2 things have nothing in common
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.