Dump Time out SQL Error Logs

[Former Member]

Hi,

In transaction DB02-diagnostics-SQL Error logs

Is occurring dump time out in the transaction DB02-diagnostics-SQL Error logs.

Any idea?

When I go into SQL Server Management Studio, management-SQL Server Logs-current, I have 2005423 records.

I believe that the problem of time out is why there are many records. How do I clean these logs ?
If I make a stop at the bank solves?

I appreciate any other suggestions also.

tks

SQL Server 2008

Windows Enterprise Server 2003.

SAP BI - 7.01

[Former Member]

Basically the SAP system is trying to read the large file from the SQL System and timing out. You can increase the timeout value if you want to read the file.

if you wan to reduce the fine size, if you restart your SQL server a new log file will be created. you can also create a log file by the following procedure.

http://blog.sqlauthority.com/2010/11/09/sql-server-recycle-error-log-create-new-log-file-without-ser...

What would be of bigger concern here is that why is your errorlog file so big. Seems like a repetative error, maybe a authorization error or some trace is being written to it, risk is that sometime the log file may fill up your Drive and cause SQL to crash. Look into what the error is. Post the error if you want help resolving it.

Yogesh