Production File Sizes:

MDB File Size is :- 50944 KB
Log File Size is :- 34443648 KB
Recovery Model: Full

I want to shrink the Log file .... can you tell me how can I do this ?
should I put the simple recovery model so it will shrink automatically....
or give me some good advise as this is on production...

Thanks

Placing the db into simple mode does not shrink a file.


http://www.nigelrivett.net/Transacti...leGrows_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


"msnews.microsoft.com" <Noor> wrote