SQL SERVER – SQL Daily Tip – Force Database Offline.

To force a database to bring OFFLINE you can use the next statement:

alter database DBNAME set offline with rollback immediate

this is a quickly way to force a database to set it OFFLINE, when you use this statement a rollback occurs for all the transactions running.