USE [master]
RESTORE DATABASE [DB4] 
 FROM DISK = N'D:\Backup\Backup_file.bak' WITH FILE = 1, 
MOVE N'VeeamBackup1' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.VEEAMSQL2012\MSSQL\DATA\DB4.mdf', 
MOVE N'VeeamBackup1_log' TO N'c:\Program Files\Microsoft SQL Server\MSSQL11.VEEAMSQL2012\MSSQL\DATA\DB4_log.ldf', NOUNLOAD, STATS = 5

GO
Advertisements