SQL Log Rescue Timeout expired message
chris.buckingham
Posts: 59
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]
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
Red-Gate support
