Bring database offline online T-SQL

— Bring Database Offline

USE master
GO
ALTER DATABASE YourDatabaseName
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO

— Bring database online

USE master
ALTER DATABASE SET ONLINE
GO

Advertisements