I am having trouble with my SQL Server 2008 R2 instance.
First, one of my databases on this instance seems to have crashed. When I try to drop it, I am getting the error message below.
Msg 3702, Level 16, State 3, Line 2
Cannot drop database “DataBaseName” because it is currently in use.
I needed to drop the crashed database and recreate it from scratch. I couldn't rename it either.
Now I try to restart the instance and it seems to hung, with the State column showing 'change pending...'
What's acting up?