September 9, 2005 at 8:23 am
Hi, after installation of SP4 (SQL 2000) , from time to time I get this error:
Process 55:0 (9f8) UMS Context 0x0027D6D8 appears to be non-yielding on Scheduler 1.
I tried to search ms kb but none of the possible causes they describe (CHECKPOINT, DBCC DBREINDEX etc.) seem to apply to my problem. This error appears at the end of my backup procedure during the automatic deletion of the old backup files using sp_dropdevice. These files are about 35 GBs. Before applying SP4 I never saw this error. Although all seems to work fine - new backups are valid and restorable and the old backups get deleted, I'm bit uneasy about it and I'm trying to find a solution. Any ideas? Thanks in advance.
September 9, 2005 at 10:26 am
I think some improved reporting was added with sp4 - certainly I've heard of some users uninstalling because of errors like this, but I think if you search msdn /technet you'll find this is added functionality and not anything you need to worry about.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
September 9, 2005 at 10:30 am
try this as a starting point
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqldev/html/sqldev_04222005.asp
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
September 12, 2005 at 5:01 am
Thank you for your replies. I'll probably stick with SP4 and live with these error messages.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply