Making a MS SQL Offline Database Online

39 Reads Ms Sql

The following code is run to bring a database online in MS SQL Server.

ALTER DATABASE {Our Database Name} SET ONLINE

It is used as follows.

ALTER DATABASE [OurDB] SET ONLINE

After performing this operation, it will be seen that there is no change in the left panel (Object Explorer). To see this change, right click on the Databases folder and "Refresh".

Ms Sql

You May Interest

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

Benefits of Using Stored Procedures in MS SQL

Deleting Columns From a Table with a Query in MS SQL

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

What is The Difference Between The Index Seek and Index Scan in S ...