Making a MS SQL Offline Database Online

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".



You May Interest

What is The Concept of Piecemeal Restore on SQL Server ?

What are Wait Types in SQL Server ?

What is SQL Profiler ?

What are the Limitations of Indexed Views in SQL Server ?

What is the Difference Between VARCHAR and NVARCHAR in SQL Server ...