Offline a single database in MS SQL Server

It is quiet easy to bring a single database offline in MS SQL Server, rather than bringing the whole database down.

There is a bit of difference in SQL Server and Oracle database.

In Oracle we can associate a single instance with a single database. To bring down the database we can just shutdown the instance.

Whereas, in MS SQL Server, in a single instance we have multiple databases running. To bring down all databases, just shutdown the single instance. Or we can just shut down a single database at a time.

In order to bring a single database offline we need to perform the following steps:

1. Update database property AUTO CLOSE to TRUE.
This brings database offline once all sessions are disconnected. Once a session wants to access the database again, it will automatically bring database online.

2. Right Click the database, select option TASKS -- Take Offline

Once offline the following prompt is shown.

Hope this helps...........