Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to RoboCopy backup files between servers Expand / Collapse
Author
Message
Posted Wednesday, May 7, 2008 10:38 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 2:40 PM
Points: 759, Visits: 645
Hi,
Can anyone explain the process of How to RoboCopy backup files between servers.

In my case i want to send the backup files from local server to a remote server for storage and want to create a daily schedule.

Thanks
Post #496512
Posted Wednesday, May 7, 2008 11:21 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, November 12, 2013 8:44 AM
Points: 1,073, Visits: 6,334
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 * 

Post #496547
Posted Friday, May 9, 2008 12:44 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 30, 2009 6:33 AM
Points: 19, Visits: 27
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..


Carlos Campos
System Administrator & Now DBA Admin
Post #497611
Posted Wednesday, March 12, 2014 7:10 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, August 21, 2014 7:17 AM
Points: 58, Visits: 392
Also check:
Quick and Dirty DR Solution Using Robocopy
Post #1550216
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse