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.