Copy .bak file to another Windows server

Asked Jul 19 '13 at 17:09

Active Jul 19 '13 at 17:15

Viewed 2,195 times

I have .bak files that created by a job on SQL Server every night. I want the .bak file to be copied to another server. I created a job running the command

EXEC xp_cmdshell 'copy "G:\Source\folder\file.bak" "\\destination\Work\folder\"'

but the job creates the a copy of the .bak file on the source machine but in different directory.

Any idea about what I am doing wrong?

Thanks

edited Jul 19 '13 at 17:15

marc_s

732,580
175
1,330
1,459

asked Jul 19 '13 at 17:09

Zeze

Is `Destination` the name of the second server? – Yuriy Galanter Jul 19 '13 at 17:14
It works for me, try this `'copy "G:\Source\folder\file.bak" "\\destination\Work\folder\file.bak"'` – Gaston Flores Jul 19 '13 at 17:33
1

Does the account that SQL Server runs under even have access permissions to that remote server? – marc_s Jul 19 '13 at 18:12

Copy .bak file to another Windows server

0 Answers0