Declare @dbname NVARCHAR(MAX), @filepath Varchar(Max), @user Varchar(Max), @pw Varchar(Max)
SET @dbname = '[Essers.TOR2]'
SET @filepath = 'D:\dev\databases\essers\tor 2.0\160704-batch.bak'
SET @user = 'tor'
SET @pw = 'tor'

USE master
Exec('ALTER DATABASE ' + @dbname + ' set offline with rollback immediate')
Exec('ALTER DATABASE ' + @dbname + '  set online')
Exec('RESTORE DATABASE ' + @dbname + ' FROM DISK = N''' + @filepath + ''' WITH RESTRICTED_USER , FILE = 1 , NOUNLOAD , REPLACE , STATS = 10')


-- first create new login for the specific DB
-- link existing login and existing user
EXEC sp_change_users_login 'Auto_Fix', @user
-- change password
Exec('ALTER LOGIN tor WITH PASSWORD = '+ @pw)