How to close all connections on a database ?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

GRE (Gethyn Ellis) SSCrazy Eights Points: 9602 More actions · Answer 1

ALTER DATABASE DBNAMESET SINGLE_USER WITH ROLLBACK IMMEDIATE

The database will be in single user mode after this has run.

Gethyn Elliswww.gethynellis.com

SQL Guy 1 SSCoach Points: 15979 More actions · Answer 2

Thanks Gethyn

This is exacltly what I needed. Also, should I set it to multi user after restore ?

Jeffrey Williams SSC Guru Points: 90314 More actions · Answer 3

If the database was not backed up while in single user mode, then it will not be restored in that condition. So, no - you won't need to set it back.

You could also use the following:

ALTER DATABASE {your database} SET OFFLINE WITH ROLLBACK IMMEDIATE;

Then perform your restore. This will prevent any other processes from taking the single user connection and blocking your restore.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll