What is a checkpoint in DBMS and when does it occur?

All Questions › Category: Database › What is a checkpoint in DBMS and when does it occur?
0 Vote Up Vote Down
chetan shidling asked 4 years ago

I need short information.

1 Answers
0 Vote Up Vote Down
chetan shidling answered 4 years ago

A checkpoint is a mechanism where all the previous logs are removed from the system and are permanently stored on the storage disk. So, basically, checkpoints are those points from where the transaction log record can be used to recover all the committed data up to the point of crash.