up vote 2 down vote favorite
share [g+] share [fb]

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?

link|improve this question
44% accept rate
3  
-1 for answering your own question 3 minutes after posting. Perhaps you can do a more thorough search before asking vague questions next time? – 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
Huh? Since when does answering own question is bad? And which part is vague? Weirdo... – Adrian Godong Jul 26 '09 at 1:37
feedback

1 Answer

up vote 3 down vote accepted

Found the answer using ALTER DATABASE.

ALTER DATABASE <database_name> SET MULTI_USER WITH ROLLBACK IMMEDIATE
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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