Sample Header Ad - 728x90

Can a offline database be in use?

3 votes
2 answers
2037 views
I have a SQL Server 2014 DB where the log file filled up the disk. Since it was a test db, we decided to just delete the whole database. We took it offline, but when we try to drop it, we get a message that it cannot be dropped since it is in use. How can it be in use when it is offline? How can I get it dropped? (Preferable without taking it online.)
Asked by GHauan (615 rep)
Jun 13, 2017, 08:15 PM
Last activity: Aug 27, 2020, 07:31 PM