Home / server / Questions / 45275
Accepted
Adrian Godong
Asked: 2009-07-25 08:52:23 +0800 CST

Cancel Database Take Offline

  • 772

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?

sql-server-2005

1 Answers

  1. Best Answer

    Found the answer using ALTER DATABASE.

    ALTER DATABASE <database_name> SET MULTI_USER WITH ROLLBACK IMMEDIATE
    • 8