I'm simply trying to delete a database from SQL 2012 manangement studio by right-clicking and selecting delete. I have waited over 10 minutes then had to end task. I tried this directly on the server itself and same thing. In 2008 it took seconds. Why is this not working?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Unable to delete database in SQL 2012
- Thread starter Luvsql
- Start date
How big of a database? Most likely someone is using the database, and blocking your drop command. Set the database to restricted_user mode, and issue the drop again. It is best to issue that from SQLCMD, because Management studio takes out a bunch of connections you may not realize are there. The Intellisense "helper" is the first one I shut off.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question