Checkpoint in SQL SERVER:
When
we done operation on SQL SERVER that is not committed directly to the
database. All operation must be logged in to Transaction Log files after
that they should be done on to the main database. Checkpoint are the
point which alert Sql Server to save all the data to main database if no
check point is there then log files get full we can use Checkpoint
command to commit all data in the SQL SERVER. When we stop the SQL
Server it will take long time because Checkpoint is also fired.
No comments:
Post a Comment