The Multifunctioning DBA

Oct 5 2011   1:52PM GMT

I need some help



Posted by: Colin Smith
Tags:
background spid
Help

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

thanks

 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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: