The Multifunctioning DBA

Oct 5 2011   1:52PM GMT

I need some help

Colin Smith Colin Smith Profile: Colin Smith

Yesterday I had an interesting issue that I had never run into before. I attempted to drop a database in SQL Server 2008 SP1 and it failed and it moved the database into single user mode. I attempted the drop again and it failed saying the database was in single user mode and a user was already in it. I ran an sp_who and i found that spid 12 was in my database and the command was checkpoint. That never changed and as you know I can not kill that spid since it is not a user session. I had to restart the instance in order to get that session out of my database and then I was able to drop the database. Why did that spid stick in my db though? How can I get it out without restarting if it happens again? If you have any clue please help me out. I am stumped by this one. Please leave a comment here or hit me up on twitter, @smithco32


 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: