How to RoboCopy backup files between servers

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Todd Engen SSCrazy Eights Points: 9869 More actions · Answer 1

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 *

carlos.campos-hidalgo SSC Enthusiast Points: 175 More actions · Answer 2

I use the follow sentence:

Robocopy e:\mssql\backup\bkAP.bak \\DestinationServer\f$\mssql\backup\bkAP.bak /MIR /SEC /Log:c:\temp\bkAP.log

The parameter /log if because I have a script that check if the robocopy has finish OK.

I hope that this POST results OK

Carlos Campos

System Adminstrator & now DBA Admin..

poldi.rijke Old Hand Points: 351 More actions · Answer 3

Also check:

Quick and Dirty DR Solution Using Robocopy[/url]

garrybrownn96 Grasshopper Points: 21 More actions · Answer 4

I would like to suggest you, try Long Path Tool program to resolve this issue.

Cookies on SQLServerCentral