Automated backup of historian and other db tables to folder

General Discussion
1

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?

Thanks,
Cam

2

Replication is your answer.

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