Home > DeveloperSection > Interviews > What are Checkpoints in SqlServer?

Posted on    May-11-2011 4:57 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  1344  View(s)
Rate this:

Awadhendra Tiwari

Total Post:510

Points:2550
Posted on    May-11-2011 12:00 AM

When we done operation on SQL SERVER that is not commited 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.

Don't want to miss updates? Please click the below button!

Follow MindStick