asked
xcopy to copy db files from one server to another server
hi i need to configure the sql jobs to copying sql server backup files from one server to another server with using xcopy method.
This web site works by voting. For all helpful answers below, indicate this by clicking on the thumbs up next to those answers. If any one answer lead to a solution, indicate this by clicking on the check mark next to that answer.
In order to do this you need to write a procedure in the destination server you need to NETUSE command and map the server and then need to write a code to copy using XCOPY or ROBOCOPY(much faster than XCOPY)and then you can schedule a job using this proc.
You could also use PowerShell (either via robocopy or using the Copy-Item cmdlet) to do this. Might be a bit less involved. Certainly a bit more current. But whether you can depends on your environment and circumstances. Copy-Item:
http://technet.microsoft.com/en-us/library/hh849793.aspx Run PowerShell via SQL Agent:
http://msdn.microsoft.com/en-us/library/hh213688.aspx
17 People are following this question.
