What is Check point? Explain in Brief what it will do?



What is Check point? Explain in Brief what it will do?..

Answer / samba shiva reddy . m

When we done operation on SQL SERVER that is not commited directly to the database example:we are deleting bulk records from server but in between power shut down or some thing happened then that transaction is not committed from our side if we create check point on that delete statement after deleting some records it will save as check point next no need to delete those records again if check point is not there means we have to start form scratch.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.

Is This Answer Correct ?    3 Yes 2 No

Post New Answer

More SQL Server Interview Questions

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,


How to find the date and time of last updated table?

6 Answers   Teledata,


What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,


How are SQL Server databases physically stored under Windows 2000?

1 Answers  


How to update muliple row in single query?

0 Answers   MCN Solutions,






Do you know how to send email from database?

0 Answers  


What is difference between count (*) and count 1?

0 Answers  


Hi..here i would like to know the Backup and Restore models?

2 Answers   HCL,


write sql program to get the detail of student in a class?

2 Answers  


what are the critical issues you have resloved in your company

0 Answers   Wipro,


What is postgresql server?

0 Answers  


What do you know about system database? : SQL Server Architecture

0 Answers  


Categories