Home Forums SQL Server 2005 Backups How to RoboCopy backup files between servers RE: How to RoboCopy backup files between servers

  • Usage information for that utility can be displayed by typing three question marks after the name.

    ROBOCOPY /???

    For a single file copy it would look something like this; where SERVER1 is the source and SERVER2 is the destination.

    ROBOCOPY \\SERVER1\MyShare \\SERVER2\MyShare MyFile.bak

    The above could be placed in a batch file then scheduled using scheduled tasks.

    Here's a command line example of setting up a new task to run daily at 11:00pm as a specific user.

    SCHTASK /Create /SC DAILY /ST 23:00:00 /TN MyTaskName /TR myBackup.cmd /RU mydomain\myusername /RP *