[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

how to turn online a database

Posted on 2014-02-13
1
Medium Priority
?
285 Views
Last Modified: 2014-02-13
Hi experts,

I am trying to turn online a database that i see it as offline on Microsoft SQL Server Management Studio.

Any suggestion ?

THanks
0
Comment
Question by:shpresa
1 Comment
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 2000 total points
ID: 39857631
right click on the database -> tasks -> bring online

or

run this statement

ALTER DATABASE yourDatabaseName
SET online
GO
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question