How to setting checkpoint in transaction log

[zircon06]

Anyone enlighten me steps for settings for check point when doing transaction logs.

Thanks

 

[ptheriault]

you should let SQL Server manage the checkpoint for you. You could cause serious problems with performance by changing the checkpoint value. Here is the BOL link about checkpoint.

http://msdn2.microsoft.com/en-us/library/aa174542(SQL.80).aspx

- Paul
- If at first you don't succeed, find out if the loser gets anything.