How to bring your SQL database online

Winhost > Databases > MS SQL
If you accidentally bring your SQL database offline and cannot connect to the SQL Server, here's how to bring it back online.
  • Open Management Studio and in the "Connect to Server" dialog box enter your connection parameters
  • Click the "Options >>" button and navigate to the "Connections Properties" page
  • In the "Connect to database" dialog box type the word master.
  • Open up a New Query window and paste the following T-SQL code into it:
 
USE [master]
GO
  
ALTER DATABASE [DB_123_database] SET ONLINE
GO
 
Replace DB_123_database with your actual database (the one you are trying to bring online)
  • Execute the code
  • If the code executed successfully, but you do not see the change in your database status, disconnect from the server and connect again. This time, you can connect to your default database instead of master.
In addition to backing up your site files, our SiteBackup service can also back up your databases. Now you can control backup retention and schedule. Automate your backups with SiteBackup.
Article ID: 769, , Modified: 7/11/2016 at 3:43 PM

Was this article helpful?

Share this article