How to take MSSQL database offline or bring it online?

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 [Reference URL].

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

    Expand Databases Option and Locate your Database from List

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

    Right Click the Database and Select Tasks > Take Offline Option

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

    A Message Appear After Taking a Database Offline


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.

    Expand Databases Option and Locate the Offline Database

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

    Right Click the Database and Select Tasks > Bring Online

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

    A Message Appear After Bringing a Database Online


  • 0 Users Found This Useful

Was this answer helpful?


Related Articles

Microsoft SQL Server 2016 Recommendation

The SQL Server 2016 Express is the latest data management system from the Microsoft. Like the...

Fix : Server Unable to load user-specified certificate. The server will not accept a connection

You may encounter this error when you attempt to start the MSSQL service. This error occurs when...

Comparison of MS SQL Server 2014 Express Edition V/s. MS SQL Server 2014 Web Edition

Following is a brief comparison between MSSQL Server 2014 Express Edition and MSSQL Server 2014...

How to configure MSSQL server default language configuration option?

Recently, we faced strange issue wherein one of our customers was capturing error messages coming...

How to Shrink Transaction Logs of Database in MS SQL?

This article will assist you to shrink/truncate the transaction logs of database in MS SQL...