What is Check point? Explain in Brief what it will do?
- 1 Answers
- 5561 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Is INSTEAD OF trigger directly applicable to Table ?
What is the purpose of optimization?
Why are sql functions used?
Create a dts package to produce a text file using the ‘update statistics’ command for the tables in a database with obsolete statistics.
Explain following error properties?
Explain the cursor lock types?
What are the methods used to protect against sql injection attack?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain the difference between HTTP and HTTPS in database?
What is the difference between local and global temporary tables?
Explain trigger and its types?
How do you implement session management in SQL Server mode?
What does it mean to normalize data?
what method you can use to reduce the overhead of Reporting Services data sources?
What are the rendering extensions of ssrs?
