I have noticed from the newsgroup that several new users of SQL does not understand the log file. There are some exellent answers from the newsgroup too:

For example, here is a post that is worth mentioning:

> Have a look here:
> http://www.nigelrivett.net/TransactionLogFileGrows_1.html  Log File issues
> 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
> http://www.karaszi.com/SQLServer/info_dont_shrink.asp    Shrinking
> considerations
> --
> Andrew J. Kelly  SQL MVP
> "grumy" <grumy@discussions.microsoft.com> wrote in message
> news:CE8FB6F4-8F37-4A39-A7B3-ECBF1D0BC931@microsoft.com...
>> The transaction log for a very small database has shot up to 1G
>> how do i reduce this, and prevent this happening in the future?