Timeout expired while examining database logs

Category: Troubleshooting & error messages
Date: 28 May 2009
Product: SQL Log Rescue
When analyzing a database using SQL Log Rescue, the following error may occur:

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server not responding."

This message may appear regardless of whether transaction log backups or the database's live log file is being examined. The live log files can be very small, and you may notice the processor on 100% usage, showing SQLSERVER.exe using 90% in Task Manager.

The problem may be because of invalid database configuration. Checking the system files table of the SQL Server may point out any potential problem.

USE [theDatabase]
SELECT * from sysfiles1

If log files are specified here that do not exist, Log Rescue will attempt to read them anyway and fail, causing this error. Deleting the superfluous log file entry from the sysfiles1 table will prevent this problem, however, it may be advisable to examine the database at this point to determine how it got into this condition and that it is still working properly.

Document ID: KB200708000097 Keywords: Log,Rescue,sysfiles1,timeout,not,responding

Was this article helpful?

Search support