log

the database file is 112m
the log file is 2614m
but it only uses 50m of 2614m of the log file.
how can i shrink / reduce the size of the log file.
it is getting bigger. it makes me not comfortable by its size.
thanks.Make sure you either change to SIMPLE recovery mode or do regular log
backups. These should explain everything:
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 Server MVP
"tony wong" <x34@.hknet.com> wrote in message
news:OJR8$l88DHA.1548@.tk2msftngp13.phx.gbl...
> the database file is 112m
> the log file is 2614m
> but it only uses 50m of 2614m of the log file.
> how can i shrink / reduce the size of the log file.
> it is getting bigger. it makes me not comfortable by its size.
> thanks.
>
>|||Andrew, thanks a lot.
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> glsD
:Op0gQ988DHA.2760@.TK2MSFTNGP09.phx.gbl...
> Make sure you either change to SIMPLE recovery mode or do regular log
> backups. These should explain everything:
> 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 Server MVP
>
> "tony wong" <x34@.hknet.com> wrote in message
> news:OJR8$l88DHA.1548@.tk2msftngp13.phx.gbl...
>