Copy sql backup file with time stemp

Hi There,

I'm kind of new to power shell and I'm making my step up to self learn it at home however I've and issue in production that I can use some help.
I have an SQL backup directory named GC1, every Sunday a full backup is been created via the sql maintenance plan, my DBA keep about one month back for our record, so on avrage my directory looks like this:

Main directory: \\xs-nas\Public\Database\GC1\Auto

FULL_(local)_GC1_20150905_220001.sqb

FULL_(local)_GC1_20150829_220001.sqb

FULL_(local)_GC1_20150822_220002.sqb

FULL_(local)_GC1_20150815_220000.sqb

FULL_(local)_GC1_20150808_220001.sqb

As you can tell the main directory is located on a NAS, I need a script that will copy only the new "FULL" backup to another NAS that located in a different location (I do have site to site between both network with a large bandwidth)

Avrage file size is about 15GB

Hope to here from you

Manny

September 9th, 2015 7:23pm

Is there a question?

If you need a custom script then you need to post here at the bottom of the page: https://gallery.technet.microsoft.com/scriptcenter/site/requests

Read the script request instructions carefully.

Free Windows Admin Tool Kit Click here and download it now
September 9th, 2015 7:30pm

Thank you
September 10th, 2015 7:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics