I need to take a database offline immediately, but a latent connection is blocking the
SET OFFLINE operation. I attempted to take it offline from SQL Server Management Studio, which would have called
ALTER DATABASE <database_name> SET OFFLINE, instead of
ALTER DATABASE <database_name> SET OFFLINE WITH NO-WAIT like I should have.
Other attempts to access or take the database offline fail because a lock a cannot be obtained due to the blocking operation.
How can I cancel the blocking
SET OFFLINE operation without taking my entire instance offline?
Update: I ended up restarting my SQL Service instance, which quickly released the lock, but it was undesirable. I would still like to know how to kill the connections blocking a
SET OFFLINE operation.