>Can you set the frequency of checkpoints in SQL Server?
To adjust automatic checkpoints, you can mess with the recovery interval under Tools - SQL Server Configuration Properties. Increasing this will cause SQL Server to create checkpoints less frequently because it is allowed more time on the other end to handle things.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao