How to RoboCopy backup files between servers

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » How to RoboCopy backup files between servers

How to RoboCopy backup files between servers

Rate Topic

Display Mode

Topic Options

Author

Message

ALIF-662928

Posted Wednesday, May 07, 2008 10:38 AM

Right there with Babe

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 10:42 AM
Points: 759, Visits: 613

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

Todd Engen

Posted Wednesday, May 07, 2008 11:21 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, June 14, 2013 11:26 AM
Points: 1,073, Visits: 6,324

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

carlos.campos-hidalgo

Posted Friday, May 09, 2008 12:44 AM

Grasshopper

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..

w00t

Carlos Campos w00t

System Administrator & Now DBA Admin

Post #497611

« Prev Topic | Next Topic »

Permissions