Home Forums SQL Server 2005 Administering Default Database Drive Almost Full RE: Default Database Drive Almost Full
Steve Jones - SSC Editor
SSC Guru
Points: 734434
More actions
August 5, 2010 at 5:04 pm
#1203180
I think Andrew is correct. If you have that database selected in EM, or a query window open, there's a shared lock on the database.
Select master, the right click your database and select detach (or run a script from master).