I have a maintenance plan that backs up the database to disk on the server. I would like to add a step to the backup job that will either copy that BAK file to another server, or run a second backup to the other server. I need help with the command syntax though. Also what permission would I need on the other server to access it? Thanks very much for any help.
Add a step to the backup job. The second job would run xp_cmdshell using DOS copy or xcopy command. The SQL service on the the server that has the job would need write access to the folder (most likely a share) where you are copying the file to.
copy backup to another server
Posted - 07/12/2006 : 12:13:32
