Groups | Blog | Home
all groups > sql server clients > april 2005 >

sql server clients : Log file size continuously grows


Jens Süßmeyer
4/25/2005 12:00:00 AM
http://support.microsoft.com/?kbid=873235

HTH, Jens Suessmeyer.

"Farhan" <Farhan@discussions.microsoft.com> schrieb im Newsbeitrag
news:14587936-A487-4A9C-BE5E-7A2A963612CD@microsoft.com...
[quoted text, click to view]

Andrew J. Kelly
4/25/2005 12:00:00 AM
My guess would be you have an open transaction. What does DBCC OPENTRAN say
for that db?


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


[quoted text, click to view]

Farhan
4/25/2005 7:35:11 AM
Log file size continuously grows, even I placed Simple Recovery mode. Any one
AddThis Social Bookmark Button