Copy backups Script

[Stuart_C]

Hi there,

 

I need some scripting help please.

 

Every day one of the database servers backs up the databse files to disk (on the server). The files are stored in folders called Daily_YYYY_MM_DD_2300 and it creates 7, one for each day of the week, and then overwites the oldest so I always have 7 folders.

 

However I need to back them up to external storage somehow. I wanted to avoid having to delete and re-copy all the files due to slow network speeds. Basically I need to copy the newest backup folder from the source and delete the oldesst backup folder on the destination.

 

any ideas?

[mattx]

In the batch file delete the previous backup file / structure first using del, deltree or RD and then simply copy the new one into the folder.

 

del d:\backups\monday\*.backup /q

copy \\server\*.backup d:\monday

 

Or delete the files from the backup source once copied over.

[jinnantonnixx]

Robocopy with the /MIR option (mirror) will delete files on the destination that do not exist on the source.

 

 

e.g. robocopy \\source\folder \\dest\folder * /mir

 

Even though you specify the * wildcard, robocopy will not bother copying files that already exist on the destination.

 

Robocopy | SS64.com

 

 

/MIR : MIRror a directory tree - equivalent to /PURGE plus all subfolders (/E)

/PURGE : Delete dest files/folders that no longer exist in source.

Edited October 2, 2012 by jinnantonnixx

[Stuart_C]

Thanks @jinnantonnixx I'll give that a go.

[jinnantonnixx]

Be careful - as with any powerful tool things can go wrong. The /MIR will delete everything that exists in the target that does not exist on the source.

 

When testing, you might want to try the /L option, which does a dry run, without doing anything useful (or destructive).

/L : List only - don’t copy, timestamp or delete any files.