Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2007-05-08 : 06:24:59
|
| Dear Experts,please guide me, how can i run checkpoint manually? and how can i make it done automatically? what is sql server default?is it a problem (making the checkpoint to run more times)?Vinod |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-05-08 : 06:44:32
|
| Just use the CHECKPOINT command.What problem are you trying to solve?Kristen |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2007-05-08 : 07:06:08
|
| actually,I'm practicing DBCC commands,in those, while using DBCC DROPCLEANBUFFERS command, suggested that, it is better run the checkpoint before run this command.please guide me. how can i do that automatically? what is sql server default check point time?Vinod |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-08 : 10:00:15
|
| Every minute as I know. |
|
|
|
|
|
|
check point manually