beginner: sql log grow
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?
>
>
