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