Have a look at these:


http://www.support.microsoft.com/?id=317375 Log File Grows too big
http://www.support.microsoft.com/?id=110139 Log file filling up
http://www.mssqlserver.com/faq/logs-shrinklog.asp Shrink File
http://www.support.microsoft.com/?id=315512 Considerations for Autogrow
and AutoShrink
http://www.support.microsoft.com/?id=256650 INF: How to Shrink the SQL
Server 7.0 Tran Log
http://www.support.microsoft.com/?id=272318 INF: Shrinking Log in SQL
Server 2000 with DBCC SHRINKFILE


--
Andrew J. Kelly SQL MVP


[quoted text, click to view]

Dear Guys
How to Reduce the log file size in SQL2000. I have used DBCC
Shrinkfile(db_log,filesize)
but it doesn't work. The Log file size still the same
And my HD Size will be full. Have any suggestion.
thanks

There could be different reasons for that behavior. However, I would
suggest the following:

"The DBCC SHRINKFILE and DBCC SHRINKDATABASE commands will not move data
and reduce the file size if the EstimatedPages value equals the MinimumSize
value that is reported when the command completes"

For this, have a look at the following KB Article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;324432&Product=sql2k

Also, do you get some kind of error message? Try looking into the error
logs and see if that helps you to point to something.

Also, for general help on this command, please review:
http://support.microsoft.com/default.aspx?scid=kb;en-us;272318&Product=sql2k

Hope that it helps.

Sanchan [MSFT]

sanchans@online.microsoft.com

This posting is provided "AS IS" with no warranties, and confers no rights.