Discussion Locked

SQL 2000

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a stored procedure in SQL 2000 for using the truncate log on checkpoint command? OR is this now handled strickly by the backup feature ? In SQL 7 you could select the database and then go to options and mark truncate log on checkpoint.

1 reply

by jordan.wood

Log Truncation occurs when a BACKUP LOG statement is completed and every time a checkpoint is processed. Done automatically now - it's really great :)

the exception is that hte log is not truncated if the checkpoint occurs when a backup statement is still active.

read more about this in the Books Online tool in SQL2000

see ya

This discussion is closed to new replies.