Commit is what happens at the end of a transaction. A transaction in the
tran log looks like this:

Begin Tran
statement of work
statement of work
...
Commit [or Rollback]


Checkpoint is what happens to the transaction log and database. Checkpoints
happen roughly every 60 seconds; the system looks at the transaction log to
see what transactions have committed since the last checkpoint. All of
those new transactions are copied into the database and a new checkpoint
(like a bookmark) is issued in the tran log. After the checkpoint, these
transactions now exist in two places -- the tran log and the database (if
you're using Full Recovery model).

When you backup the tran log the transactions now are removed from the tran
log but still exist in two places -- the database and the backup.

The point being that you want your transactions in two places at all times.

----- Original Message -----
From: "Harsh Kumar "
<mssqldba-ezmlmshield-x54135333.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Saturday, March 31, 2007 9:06 AM
Subject: Differnece between Commit and Checkpoint


> Dear All,
>
> Can any one help to differentiate between commit and checkpoint?
>
> Thanks
>
> Harsh
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.23/740 - Release Date: 3/30/2007
> 1:15 PM
>
>


MS Sql Server LazyDBA home page