User DB is in SUSPECT state.
sp_who2 shows that is isn't being used in any SPID.
I cannot ALTER to SINGLE_USER. I have a FULL+DIFF backup combo that I restore from, but without exclusive access, I cannot restore.
ALTER DATABASE failed because a lock could not be placed on database 'MyDB'. Try again later.
Tried to DROP, having closed connections - no joy.
Tried RESTRICTED_USER just in case - no joy.
Am I missing something really obvious, or do I need to take more drastic action? (Such as restarting SQL with everyone disconnected from every SSMS on the planet... (developers on multiple continents))
Any assistance is hoped for...
I should add that the transaction log filled up the disk.
All attempts to backup the existing TLog fail due to SUSPECT presence.