SQL 2000 Trx Log will not go away

[RichS]

Hi All,
I am using SQL Server 2000 with "Simple Recovery" set. As I understand it, this is the same as "Truncate on Checkpoint" in SQL 7 in that it automatically truncates the transaction log when a CHECKPOINT is issued. However, when I run the CHECKPOINT command the transaction log remains. Other options set are "Automatically grow file" with "Unrestricted Growth" but I have tried other settings. I have also tried the "Bulk-Logged" and "Full" settings and still when I run a backup the log remains.

My transaction log is 58 meg and growing. Thanks in advance for any help.

Rich

 

[tlbroadbent]

The transaction log is not deleted when you truncate it. Nor does truncation reduce the physical size of the file. Truncation only reduces the logical file size. You need to shrink the file. See Shrinking the Transaction Log in SQL BOL.
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[RichS]

Thanks,
I turned on Auto Shrink on in options.

Rich