# Automated backup of historian and other db tables to folder

**URL:** <https://forum.inductiveautomation.com/t/automated-backup-of-historian-and-other-db-tables-to-folder/10426>\
**Category:** General Discussion\
**Created:** [September 3, 2015, 3:58am UTC](https://forum.inductiveautomation.com/t/automated-backup-of-historian-and-other-db-tables-to-folder/10426 "2015-09-03T03:58:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![CamJam](https://avatars.discourse-cdn.com/v4/letter/c/3ec8ea/32.png) [@CamJam](https://forum.inductiveautomation.com/u/CamJam)\
**Post date:** [September 3, 2015, 3:58am UTC](https://forum.inductiveautomation.com/t/automated-backup-of-historian-and-other-db-tables-to-folder/10426/1 "2015-09-03T03:58:33Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [September 3, 2015, 5:34pm UTC](https://forum.inductiveautomation.com/t/automated-backup-of-historian-and-other-db-tables-to-folder/10426/2 "2015-09-03T17:34:52Z")

</div>

Replication is your answer.

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