How to take MSSQL database offline or bring it online

At times, you may encounter situations where you need to physically relocate the database files. 

Online databases won't permit such relocation operations while in an "online" state, so you'll need to take your database offline to perform this task. 

You can achieve this through the SQL Server Management Studio interface, as outlined below: 

Steps to Take MS SQL Database Offline

1.  Login into your SQL Server Management Studio. 

2. Expand Databases option and locate the database that you wish to take offline.

3. Right click the database and select Tasks >> Take Offline.

4. Once this is done, it will show you a message as below:

Steps to Bring MS SQL Database Online: 

1. Once you are done with transferring the database files, you will require to bring the database online again.

2. For that, again expand the Databases option and locate your offline database.

3. Right click the database and select Tasks >> Bring Online.

4. Once the process is done, it will show you a message as below:

** Learn more about Azure Cloud

** Learn more about QNE Hybrid Cloud Software