SQL Server Express - take database offline
to take a database offline you need to create a new query and replace “YOUR_DATABASE” with the database you want to take offline ..
use [master]
go
alter database [YOUR_DATABASE] set offline with rollback immediate
to take it back online …
use [master]
go
alter database [YOUR_DATABASE] set online