Restore a database first making the database single user then rollingback other users transactions, then restoring the backup.

Restore Single User Database.sql

/*
 JB 20120724 - MS SQL SERVER 2008 R2
 
 Restore a database first making the database  single user then rollingback other users transactions, then restoring the backup.
 
 Notes:
 - This script is stored and shared as is.
 - Might Work on other versions.
 - Need owner privileges over database.
*/

--Get out of wherever you're working on! And let's go masteR!
use master
go

--Single user a database
ALTER DATABASE [ <<Database Name>> ] --Replace varaible for database name
SET SINGLE_USER WITH ROLLBACK IMMEDIATE
GO

--Restore Database
RESTORE DATABASE [ <<Database Name>> ] --Replace varaible for database name
FROM  DISK = N'<<Bak Filepath>>' --Replace fot database filepath
WITH  FILE = 1, NOUNLOAD,  REPLACE,  STATS = 10
GO