SQL Database Offline / Online

If the user wants to make the database offline or online below are the commands.

First Method:
To make database offline use the below query
ALTER DATABASE [Database name] SET OFFLINE

To make database online use the below query
ALTER DATABASE [Database name] SET ONLINE

Second Method:
User can also right click on the Database and select Tasks->Take Offline

select Tasks->Brink online for making Database to Online