Restore MSSQL database

restore.sql

USE [Master];

DECLARE @databaseName varchar(8000) = 'DATABASE NAME'; 
DECLARE @backupPath varchar(8000) = 'c:\path\to\database.bak'; 

DECLARE @kill varchar(8000) = '';  
SELECT @kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM sys.dm_exec_sessions
WHERE database_id  = db_id(@databaseName)

EXEC(@kill);

RESTORE DATABASE @databaseName FROM DISK = @backupPath WITH REPLACE;