-- enter single user mode
ALTER DATABASE [DatabaseName] SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- single user mode can be used for restoring backups
RESTORE DATABASE [DatabaseName] FROM DISK = '{escapedBackupFile}' WITH REPLACE

-- restore multi user mode
ALTER DATABASE [DatabaseName] SET MULTI_USER


-- when database is in restoring state, run next line
RESTORE DATABASE [DatabaseName] WITH RECOVERY