How do I force my Database to go Offline, without regard to what or who is already using it?
I tried:
ALTER DATABASE database-name SET OFFLINE;
But it's still hanging after 7 min.
I want this because I need to test the scenario.
If it's even possible?
This question is related to
sql
sql-server
tsql
sql-server-2008
You need to use WITH ROLLBACK IMMEDIATE
to boot other conections out with no regards to what or who is is already using it.
Or use WITH NO_WAIT
to not hang and not kill existing connections. See http://www.blackwasp.co.uk/SQLOffline.aspx for details
Source: Stackoverflow.com