Menu
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?
322
Login to SQL Server Management Studio. In the Object Explorer, select the database you want to take offline and right-click. In the right-click menu go to Tasks >> Take Offline. In the pop-up window, choose the check box under the Drop All Active Connections and click OK.
Right-click on a database in SSMS and choose delete. In the dialog, check the checkbox for "Close existing connections." Click the Script button at the top of the dialog.
Microsoft SQL Server can run on a network, or it can function without a network.
Using SQL Server Management StudioRight-click SQL Server Agent, and then select either Start, Stop, or Restart. In the User Account Control dialog box, click Yes.
Go offline
USE master GO ALTER DATABASE YourDatabaseName SET OFFLINE WITH ROLLBACK IMMEDIATE GO Go online
USE master GO ALTER DATABASE YourDatabaseName SET ONLINE GO 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
39
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
