Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

What are views in ms sql server?

0 Answers  


How many non clustered indexes there can be on table ?

0 Answers  


How to find table changes in sql server?

0 Answers  


What is bcp? When does it used?

0 Answers  


what is difference between Enterprise Manager and Query Analyer

6 Answers   CTS,


What is a covered index?

0 Answers  


Explain ms sql server reporting services vs crystal reports?

0 Answers  


How do I delete a sql server database?

0 Answers  


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

0 Answers   IntraLogic, Oracle,


here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

7 Answers   IBM, TCS,


Does partitioning ssd reduce performance?

0 Answers  


What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

0 Answers  


Categories