USE master
GO
ALTER DATABASE <mydatabase>
SET SINGLE_USER
--This rolls back all uncommitted transactions in the db.
WITH ROLLBACK IMMEDIATE
GO
RESTORE DATABASE <mydatabase> FILE = N'mydatabase' FROM DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Backup\mydatabase.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10
GO