Disconect users from database before Restore

[NilsBevaart]

Hi all,

I am trying to set up a procedure for a data resoration to a database that might be in use at the time of restoration. I once read there are different ways to disconnect all current users to this database to be able to start the restore job.
I cannot, however, find the method and options for this. I remember there is a way to kill all connections directly or be able to block new connections, having the database free after all users disconnect themself

Any help or backround is appriciated.
Nils

 

[dreameR25]

There is no T-SQL command that would allow you to kill off all access to a specific database. If such a command did exist, dbas would have an easy time.
You can investigate the KILL command, but I doubt if you will be able to achieve your objective with it.