Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I accidentally tried to take offline a DB via the context menu command > Tasks > Take Offline.

The process is ongoing now and no new connection can be made.

How do I cancel this process?

share|improve this question
3  
-1 for answering your own question 3 minutes after posting. Pleasey do more thorough research before asking questions. –  Ernie Jul 24 '09 at 18:06
    
I can understand both sides, but it's not a strongly discouraged behavior - serverfault.com/questions/6599/… –  Kara Marfia Jul 24 '09 at 19:05
add comment

1 Answer

up vote 7 down vote accepted

Found the answer using ALTER DATABASE.

ALTER DATABASE <database_name> SET MULTI_USER WITH ROLLBACK IMMEDIATE
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.