Transaction Log Size doesn't show correct

[Jay50]

Hi All,
I have a production database in SQL 2000 server. It is configured to truncate on check point. when ever I check the log size by right click on database and choose property and then logfile the size is keep on showing the ever growing transaction file size. I truncated the logfile and restarted the server. No new news.
The transaction log file is set to unlimited growth.
Can you please tell me how do i get the file shrink to its orginal value?? The files are set to shrink files option.
Any advice would be gratly appreciated. (The Transaction file size is 41 gig, initially it was set to 1gig)

[sduggan]

Jay,

I too had problems with non-truncating log files, but in SQL7.

I ploughed through reams of stuff in BOL and MSDN, but the crux was
issue DBCC shrinkfile,
then do a backup log truncate only

e.g.:

DBCC shrinkfile ( <log file name>, <size to shrink to in mb> )
go
backup log <DB Name> with truncate_only
go

so for my instance:

DBCC shrinkfile ( Tracker_Log, 1000 )
go
backup log Tracker with truncate_only
go

It may not show staright away as this only marks it for truncation,
and it can not truncate whilst any part of the file is active,
but as soon as it can shrink it should do.


Cheers sduggan...