How to make database offline or online

Database is made offline to move its physical files. There can be many ways to make a database offline. But there are three main methods which are used frequently to make the database offline. These methods are given below:-


1)With the help of Alter database Command:-

We can make the database offline or online with the help of the Alter database command. The Alter Database command to make the database offline is :-

    ALTER DATABASE database name SET Offline

If we want to make the database online we can use the following Alter Database command:-

  ALTER DATABASE database name SET Online

2)With the help of the Db_options:-

 We can also use the db_options command to make a database offline or online.To make a database offline we can use the following command:-

sp_dboption databasename ,’offline’,true

To make the database online we can use the following command:-

sp_dboption databasename ,’offline’,false

3)With the help of Sql server management studio:-

We can also use the Sql server management studio to make a database offline as shown in the given figure.
To make database offline we have to follow steps show in fig 1 and to bring back the database online we needs to follows the step shown in fig 2:-

Fig1
Fig2

DMCA.com

About vivekjohari

Database Consultant with more than 11.5 years of experience in database designing & programming and DBA related activities.  Had good experience on different databases like SQL Server, MySQL & Oracle, Azure SQL &  Big Data.
This entry was posted in SQL Basic Concepts, SQL Server and tagged , . Bookmark the permalink.

2 Responses to How to make database offline or online

  1. Shiva says:

    Hi Vivek,
    This is Shiva.Could you please suggest the best book (with more practical Queries) for SQL Server 2008.

    Thanks & Regards,
    Shiva
    sjshiva04@gmail.com

  2. Anonymous says:

    hello vivek ,i m sonal, i have created a software using sql database. the software working properly in one computer but i need to connect the database with several computer kindly suggest me that how could i place the database on network and connect it to my software running in different computer ..
    My email.id is sonal.nature@gmail.com

Leave a Reply