--- Kill all established connections to that DB DECLARE @Test TABLE (spid smallint, ecid smallint, status nchar(30), loginame nchar(128), hostname nchar(128), blk char(5), dbname nchar(128), cmd nchar(16), request_id int) INSERT INTO @Test EXEC sp_who SELECT * FROM @Test DECLARE @spid smallint DECLARE @sql varchar(200) SELECT @spid = MIN(SpId) FROM @Test WHERE dbname = 'YourDataBaseNameHere' WHILE @spid IS NOT NULL BEGIN SET @sql = 'KILL '+CAST(@spid as varchar(50)) EXEC (@sql) SELECT @spid = MIN(SpId) FROM @Test WHERE dbname = 'YourDataBaseNameHere' AND SpId > @spid END ALTER DATABASE Test SET SINGLE_USER BackUp----- ALTER DATABASE Test SET MULTI_USER