Return
-
Title
Error: "A timeout has occurred while waiting for SQL Server to respond to a LiteSpeed request" on -
Description
TLOG job would fail with the below error if a TLOG job is overlapping with another Diff or TLOG job:Msg 61700, Level 19, State 1, Line 0: A timeout has occurred while waiting for SQL Server to respond to a LiteSpeed request.You are attempting to backup the database with multiple operations. These can either be Native or LiteSpeed jobs.Please check the SQL Server agent for multiple Full/Log/Differential job operations for the same database.BACKUP LOG is terminating abnormally. -
Resolution
Split up the databases backup jobs.SQL Server 2000 does not database backups to run simultaneously.Please refer tohttp://www.sqlskills.com/BLOGS/KIMBERLY/post/Understanding-the-Transaction-log.aspxfor more information.