USE [master];

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

EXEC(@kill);
GO

DROP DATABASE [progtest];
GO

RESTORE DATABASE [progtest] FILE = N'progdial' FROM  DISK = N'C:\TEMP\progdial_backup_2018_03_15_140001_7668977.bak' WITH  FILE = 1,  MOVE N'progdial' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\progtest.mdf',  MOVE N'progdial_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\DATA\progtest.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO

USE [progtest];

update Configuration set value = 1 where label = 'with_vascular_access' or label = 'with_stat_access';