EXECUTE xp_cmdshell 'copy "\\SRV-BKP2\mydb Backup\dailybackup.bak" \\SRV-SQL01\Databases\mydb'
GO
RESTORE FILELISTONLY
FROM DISK = 'D:\Databases\mydb\dailybackup.bak'
GO
ALTER DATABASE mydb
SET SINGLE_USER WITH
ROLLBACK IMMEDIATE
GO
RESTORE DATABASE
FROM DISK = 'D:\Databases\mydb\dailybackup.bak'
GO
ALTER
DATABASE mydb SET
MULTI_USER
