— 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
— 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
SimpleSQLDBA | Shadab Mohammad 