程序中使用SqlDependency做了一个提醒的功能,之后发现数据库日志文件增长飞快,几天就达到了20G,
大部分都是记录了这两个错误
The query notification dialog on conversation handle '{92BB494B-330B-E411-8E48-D850E6C394A8}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service 'SqlQueryNotificationService-e32e79ee-aada-435c-a8e9-1b1ad37c6a3e' because it does not exist.</Description></Error>'.
The query notification dialog on conversation handle '{88FCFA7E-300B-E411-8E48-D850E6C394A8}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8470</Code><Description>Remote service has been dropped.</Description></Error>'.
查了一下,有说是sql server本身的bug,
http://support.microsoft.com/kb/958006/en-us
http://rusanu.com/2007/11/10/when-it-rains-it-pours/
但是,我用的是SQL Server 2008 r2,而且也都更新过了,其他的一些方案也都试过了,无果!
有没有哪位高人知道的?
http://rusanu.com/2007/11/10/when-it-rains-it-pours/还有一点儿,这篇文章没怎么看懂,他说的手动释放队列是什么意思,这个还没试过!