It seems that it is not possible to script a change of repository or to change the path of a repository. Is that correct?
The two options I have been considering instead are:
- Have a separate repository and backup copy job for each location. The script would enable the one required for the week. This would require managing quite a number of jobs.
- Create a new repository and backup job each week for the new location. Would it cause any issues (eg database clutter) to be deleting and creating backup jobs on such a regular basis?
I wondered if anyone had any thoughts on the best solution, or saw any issues I had not considered.