x

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?

more ▼

asked Jun 25, 2012 at 02:33 PM in Default

avatar image

yuvarajujogi
10 1 2 4

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Jun 25, 2012 at 03:11 PM

avatar image

Usman Butt
13.9k 6 13 21

  • the 2 things have nothing in common

Jun 25, 2012 at 03:12 PM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x222
x8

asked: Jun 25, 2012 at 02:33 PM

Seen: 3691 times

Last Updated: Jun 25, 2012 at 03:12 PM

Copyright 2017 Redgate Software. Privacy Policy