Reduce Log File Size

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
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
"cf_jian" <fongjian@.elanvital.com.tw> wrote in message
news:eBiGQK2KEHA.3852@.TK2MSFTNGP10.phx.gbl...
> 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...&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...&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.