Wednesday, 2 October 2013

Database won't delete

Database won't delete

A database appeared in Sql Server that I can't seem to get rid of. It is
empty, and I am not sure how it got there, but it may be because I have
been playing around with Sql Server Projects in VS, including publishing
them to Sql Server.
When I try to delete, it just hangs in SSMS, until I force the window to
close by closing SSMS.
Have tried taking it offline, and then backonline again, but still refuses
to delete.
Also tried restarting Sql Server but still won't delete.
It started out in Single User mode, so I switched it to multi-user mode,
but no luck.
Any suggestions?
Greg

No comments:

Post a Comment