SQL Server Performance Forum – Threads Archive
steps for creating checkpointsI have given a task to create the checkpoints in the database so as to restrict the growth of my trasaction logs. Can you pls help me out with the best practices and
steps to follow for creating the checkpoints.
Thanks in advance.
Checkpoint will only have an effect if your database is in SIMPLE recovery mode. You can schedule checkpoint as frequently as you want using SQL Server Agent. The syntax is simple… CHECKPOINT. If your database is in full recovery mode you need also to schedule a backup job to back up the transaction log on a regular basis to stop it growing. Tom Pullen
DBA, Oxfam GB
thanks a lot Tom for your quick response and help