Backup and copy
-
Hi, so the senario is this. My network/storage/wintel admin guy has set up a remote backup server as currently the SAN is not replicated. So he wants all the SQ: back ups to backup directly to the remote site. ie its our DR..any way over the weekend the back up server died and it took a number of days to recover which means either no backups or I have to change the backup location on all servers.
What I am looking at doing is backing up locally. Once that has happened to robocopy or xcopy or what ever the backup to the remote backup server. For the mantenance I would like to keep 2days backups locally and the rest a weeks worth on the remote site. They all get backup up to tape from the reomote site. I want to ensure that I dont delete any files I need locally and make sure when I do the copy that it is only the required file I do copy and not all of the *.bak or *.trn on the local machine.
Hope this m akes sence and look forward to your ideas...
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
robocopy will do what you need, thats how we manage shipping BAKfiles from prod to DR, but use logshipping for TRN's to provide the DR so we dont need to restore its all done automatically.
if your using maintenance plans which delete BAK/TRN files after a certain age then there is nothing you will need to do as it should do a folder to folder merge so anything deleted on prod will be deleted in DR when the robocopy job runs
-
But how would I maintain only 2 days backups locally while I maintain a months worth of backups on a the remote backup server ??
Hope this helps...
Ford Fairlane
Rock and Roll Detective -
Use the MAXAGE switch in robocopy and give it a values, eg 7 for 7 days,
This is the URL I use for robocopy switches
-
Thanks for that 🙂
Now to build the scripts .... :hehe:
Hope this helps...
Ford Fairlane
Rock and Roll Detective
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply