@ 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