ALTER DATABASE [YourDatabase] SET EMERGENCY


ALTER DATABASE [YourDatabase] SET SINGLE_USER WITH ROLLBACK IMMEDIATE


ALTER DATABASE [YourDatabase] SET ONLINE


ALTER DATABASE [YourDatabase] SET MULTI_USER