Here’s a handy piece of code to put before a backup or snapshot-restore, where you need to kill current connections …
--first remove any connections
USE master
GO
DECLARE @kill varchar(8000) = '';
SELECT @kill=@kill+'kill '+convert(varchar(5),spid)+';'
FROM master..sysprocesses
WHERE dbid=db_id('SomeDatabaseName')
AND spid>50;
EXEC (@kill);
Database Consultant 