# Archiving and restoration of old Tag Historian Database Datasets, is it possible?

**URL:** <https://forum.inductiveautomation.com/t/archiving-and-restoration-of-old-tag-historian-database-datasets-is-it-possible/85731>\
**Category:** Ignition\
**Created:** [February 15, 2024, 2:21am UTC](https://forum.inductiveautomation.com/t/archiving-and-restoration-of-old-tag-historian-database-datasets-is-it-possible/85731 "2024-02-15T02:21:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Craig\_Rathbone](https://avatars.discourse-cdn.com/v4/letter/c/3ec8ea/32.png) [@Craig\_Rathbone](https://forum.inductiveautomation.com/u/Craig_Rathbone)\
**Post date:** [February 15, 2024, 2:21am UTC](https://forum.inductiveautomation.com/t/archiving-and-restoration-of-old-tag-historian-database-datasets-is-it-possible/85731/1 "2024-02-15T02:21:15Z")

</div>

Hello all,

I've been asked whether it is possible to save/restore tag history data later on.  
For example, I have my Tag Historian POSTGRESQL database partitioning every month, is it possible to save that partition and restore it at a later date should it be required for review (say of commissioning data).

Anyone done this? I haven't looked too hard yet, but it looks like it would be a very manual process!

I was thinking of:

Back up sqlth\_data\_x\_yyyy\_d  
back up annotations table  
back up or note values in sqlth\_partitions  
back up sql\_te  
Then

restore data table (in to say a dev system)  
restore sqlth\_te  
restore annotations  
add references for the data tables with the start/end datetime sas per the partition table.

Is this feasable?