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.
Printable View
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.
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.