Category: sql-server

sql-server

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 immediateuse [master] go alter database [YOUR_DATABASE] set offline with rollback immediate to take it back online … use [master] go alter …