copy backup file xp_cmdshell

[hcoomer]

What is the syntax for using xp_smdshell to copy a file from 1 server to another?
Our Report server is restored from our production server and I want to copy the .dat
file from the production server to a folder on the report server.

[deepak]

xp_cmdshell 'copy \xyz c:'
This is if you want to copy a file from the machine which is not the current server to the current server machine.
x = host name of the machine from where you wish to copy the file.
y = share name
z = file name.

The above commad copies a file onto the c: of the current SQL Server.

Deepak.


------------
hcoomer at 1/4/00 10:10:59 AM

What is the syntax for using xp_smdshell to copy a file from 1 server to another?
Our Report server is restored from our production server and I want to copy the .dat
file from the production server to a folder on the report server.