SQL Log Rescue Timeout expired message

Undo for SQL Server.

Moderator: eddie davis

SQL Log Rescue Timeout expired message

Postby chris.buckingham » Thu Aug 02, 2007 12:58 pm

Using SQL Log Rescue -
Message 'Timeout expired. The timeout period elapsed prior to completion of the operation or the server not responding.'

User getting error message when trying to load Log ( from backup file ) or live Log File. Currently their log file size in database is less than 6MB but it is timing out, and also making the processor on 100% usage showing SQLSERVER.exe using 90% in Task Manager.

This problem was solved by the user checking sysfiles1 (system table) of their database and finding that there was one log file path which was not in the current setup. This line was removed and it reads the log file at normal speed.

[See 'Timout expired' also on this forum]
Chris Buckingham
Red-Gate support
chris.buckingham
 
Posts: 56
Joined: Mon Jul 30, 2007 1:39 pm

Return to SQL Log Rescue

Who is online

Users browsing this forum: No registered users and 0 guests