SQL queries time out during backup

Hello, I am new to the forum and hopefully someone can help me with the

problem I have. Lately, I noticed that my sql statements are timing out

during the time SQL server is running backup job. The errors I am

seeing in the log are:

Process 59:0 (724) UMS Context 0x06403BC0 appears to be non-yielding on Scheduler 1.

Error: 17883, Severity: 1, State: 0

I am running SQL Server 2000, Enterprise (SP4)

I believe this problem should have been fixed in SP3a. I even tried

rolling back to SP3a, but still experience the same problem. Does

anyone else have experienced this issue?

Thanks.

[603 byte] By [calbear] at [2008-2-20]
# 1

Can you send your SQL errorlog file to me at kfarlee@microsoft.com?

It is located in the SQL install tree : Program Files\Microsoft SQL Server\MSSQL$<instance>\LOG and should be named ERRORLOG. Please send one that covers the time when one of these failures happened.

Thanks,

KevinFarlee at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Disaster Recovery and Availability...
# 2
We have 12 or more 17883s fixed post SP4. Review the following, it should help.

http://download.microsoft.com/download/4/f/8/4f8f2dc9-a9a7-4b68-98cb-163482c95e0b/DiagandCorrectErrs.doc

BobDorr at 2007-8-30 > top of Msdn Tech,SQL Server,SQL Server Disaster Recovery and Availability...

SQL Server

Site Classified