sqlcmd -S 127.0.0.1\WD -i "c:\MSSQLBackupTools\BackupMSSQL\backup_script.sql" -o "B:\DB_BACKUP\INFOs\logfile_sql.txt"

select getdate(), '------------------------------------------------------'

use DB1
BACKUP DATABASE DB1 TO DISK = 'B:\DB_BACKUP\DB1.bak' with init, compression
go

select getdate(), '------------------------------------------------------'

use DB2
BACKUP DATABASE DB2 TO DISK = 'B:\DB_BACKUP\DB2.bak' with init, compression
go

select getdate(), '------------------------------------------------------'

RESTORE DATABASE DB1
FROM DISK = 'X:\MSSQLBackup\DB1.bak'
WITH
   MOVE 'DB1' TO 'D:\DB-Files\DB1.mdf',
   MOVE 'DB1_log' TO 'D:\DB-Files\DB1_log.ldf'


RESTORE DATABASE DB2
FROM DISK = 'X:\MSSQLBackup\DB2.bak'
WITH
   MOVE DB2' TO 'D:\DB-Files\DB2.mdf',
   MOVE DB2_log' TO 'D:\DB-Files\DB2_log.ldf'