Making a MS SQL Database Offline
The following code is run to take a database to offline mode in MS SQL Server.
ALTER DATABASE {Database Name} SET OFFLINEAn example of its use is as follows.
ALTER DATABASE [OurDB] SET OFFLINEAfter 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".