Diadem Technologies Support Knowledgebase

How to take MSSQL database offline or bring it online

Article ID: 1098
Last updated: 19 Jul, 2018

Sometimes, you come across to a situations when you are required to physically move the database files. Online databases will not allow you such moving operations on “online” status therefore, you will require to take your database offline to accomplish it. You can do it from SQL Server Management Studio interface as mentioned 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:

This article was:  
Report an issue
Article ID: 1098
Last updated: 19 Jul, 2018
Revision: 1
Views: 251
Comments: 0