C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Murali (143)
Bunty (130)
Deepika Harida... (129)

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

CheckPoint in SQL Server

Posted Date: 17 Jun 2008 Resource Type: Definitions Category: General

Posted By: Phani Member Level: Silver
Rating:

Points: 5

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.

Responses

Author: Bunty 21 Jun 2008

Member Level: Diamond Points : 2

Hi,
Nice attempt to clarify what is the use check point in SQL sever database.
But I have a one doubt,How to set a check point in SQL Server.If you explain it,it would be helpful for me and others too.
If you include some more content,it will be helpful for us to understand how to use check point and what are it's benifit.
Thanks.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to seperate comma from a string in MYSQL
	Previous Resource: Trigger
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj