10

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?

Adrian Godong
  • 577
  • 4
  • 9
  • 20
  • 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 - http://serverfault.com/questions/6599/is-it-ok-to-ask-and-answer-your-own-question – Kara Marfia Jul 24 '09 at 19:05
  • 1
    @Ernie actually "Stack Exchange has always explicitly encouraged users to answer their own questions" as per http://serverfault.com/help/self-answer – Seph Mar 23 '15 at 16:02

1 Answers1

8

Found the answer using ALTER DATABASE.

ALTER DATABASE <database_name> SET MULTI_USER WITH ROLLBACK IMMEDIATE
Adrian Godong
  • 577
  • 4
  • 9
  • 20