How do you kick users out of a SQL Server 2008 database?

Question

We need to do a restore, and cannot because other users are connected. We thought we had disconnected every process, but apparently not.

How can we, from Management Studio, kick off everyone else so we can do this backup?

Answer 1

There are two ways of doing it:

1) Right click on the database in Object Explorer go to Tasks > Detach. Select the Drop Connections checkbox.

2) Set the database to single-user mode as outlined here:

http://msdn.microsoft.com/en-us/library/ms345598.aspx

Answer 2

I always use:

ALTER DATABASE [dbname] SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

Answer 3

I use this code:

ALTER DATABASE [Dbname] set offline with rollback immediate
GO
ALTER DATABASE [Dbname] set online
GO

But I can see the SINGLE USER example is less to type.