Automated backup of historian and other db tables to folder

Hi Guys,
I’ after a process to create a backup of the historical tag data, transaction group data, audit log, alarm log etc for project DB’s, on a regular basis (say monthly).
This is in case something happens and the data is lost, and a gateway backup needs to be reinstalled. The idea is for the project can go back to a previous state with historical data intact.

I’m after a simple solution, maybe even a gateway script that can call a stored procedure, but haven’t quite found anything yet.
I’m mainly using MySQL and MSSQL DB’s for projects

Has anyone attempted anything like this?


Replication is your answer.

Then you can offline and backup the replicant anytime you want using batch/cron/scripting.