How to make the database offline? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to make the database offline?

Plz reply me with the details that how to make a database offline by the query analyser ???
ALTER DATABASE yourdbname SET OFFLINE
KH
I think you need to kill all connections before taking the database offline… ALTER DATABASE yourdbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO
ALTER DATABASE yourdbname SET OFFLINE MohammedU.
Moderator
SQL-Server-Performance.com
]]>