Db_Dev_Restore.sql

use master
go

ALTER database [TradeHero_DEV]
SET single_user with rollback immediate
go

DECLARE @smt  nvarchar(4000)
DECLARE @File_Exists int
DECLARE @FileName varchar(255)

SET @FileName='H:\FTPs\TH_BAK_' +  replace(convert(varchar, getdate(), 111), '/', '-') + ' 000000.BAK'
EXEC Master.dbo.xp_fileexist @FileName, @File_Exists OUT 
IF @File_Exists = 1
BEGIN
  SET @smt = N'RESTORE DATABASE [TradeHero_DEV] FROM DISK ='''+ @FileName + ''' WITH FILE = 1, MOVE N''tradehero'' TO N''E:\DBs\TH_DEV.mdf'', MOVE N''tradehero_log'' TO N''E:\LOGs\TH_DEV.ldf'',  NOUNLOAD,  REPLACE,  STATS = 5'
  execute sp_executesql @smt
END
ELSE PRINT 'Error: Backup file '+ @FileName +' not found!!' 
GO

ALTER database [TradeHero_DEV]	
SET multi_user
GO