The Multifunctioning DBA

Jun 21 2011   3:54PM GMT

SPIDS disconnecting from DB

Colin Smith Colin Smith Profile: Colin Smith

Ever run into the following issue?

<Date><Time> <spid> Error: 18056, Severity: 20, State: 29.

I did and it was a mess. Production system just starting dropping spids. It finally stopped with me doing nothing except trying to find out what it was. It took a while but I finally got it figured out. This is a bug in SQL Server 2008 and is patched in SP1 CU14. Here is a link to the article.

I applied SP2 and have not seen the issue since. Hope this will help.

 Comment on this Post

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when other members comment.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

Share this item with your network: