SQL 2005 generates 1000's of logs

SQL 2005 generates 1000's of logs

Post by TWFyY3V » Wed, 14 Nov 2007 19:01:00


Microsoft SQL Server 2005 - 9.00.1406.00 (Intel X86) Mar 3 2007 18:40:02
Copyright (c) 1988-2005 Microsoft Corporation Standard Edition on Windows NT
5.2 (Build 3790: Service Pack 2)

This has happened several times now I came in this morning to find the C
drive of our server empty and the location 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\LOG' has 12gig of log files generated. The cause I
believe is MOSS Search crawling. I have throttled the errors in Central admin
however in trying to diagnose other issues yesterday I turned some back on
and again no space due to logs.

Is there anyway to resolve this

Many Thanks

Marcus
 
 
 

SQL 2005 generates 1000's of logs

Post by Uri Diman » Wed, 14 Nov 2007 19:10:49