@echo off
osql -S192.168.1.25 -Usa -P123456 -Q"BACKUP DATABASE [ELTMS] TO DISK = N'D:\TMS\DataBase\ELTMS.bak' WITH NOFORMAT, INIT, NAME = N'ELTMS-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
osql -S192.168.1.25 -Usa -P123456 -Q"BACKUP DATABASE [ELTMS_SAP] TO DISK = N'D:\TMS\DataBase\ELTMS_SAP.bak' WITH NOFORMAT, INIT, NAME = N'ELTMS_SAP-Full Database Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10"
copy \\192.168.1.25\tms\DataBase\ELTMS_SAP.bak d:\ /y
copy \\192.168.1.25\tms\DataBase\ELTMS.bak d:\ /y
osql -S127.0.0.1 -Usa -P123456 -Q"RESTORE DATABASE [ELTMS] FROM DISK = N'D:\ELTMS.bak' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10"
osql -S127.0.0.1 -Usa -P123456 -Q"RESTORE DATABASE [ELTMS_SAP] FROM DISK = N'D:\ELTMS_SAP.bak' WITH FILE = 1, MOVE N'ELTMS_SAP_log' TO N'd:\ELTMS_SAP.ldf', NOUNLOAD, REPLACE, STATS = 10"
pause
