# Accidentally deleted tag history table

**URL:** <https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904>\
**Category:** Ignition\
**Created:** [February 21, 2013, 1:23pm UTC](https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904 "2013-02-21T13:23:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [February 21, 2013, 1:23pm UTC](https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904/1 "2013-02-21T13:23:10Z")

</div>

how can I make Ignition regenerate the sqltag history table in the database if I accidentally deleted it? Ive tried restarting but that didnt do the trick. Im not trying to recover anything, just trying to get it to start storing data again.

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [February 21, 2013, 4:44pm UTC](https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904/2 "2013-02-21T16:44:26Z")

</div>

You can try to disable the Tag History Provider, save, then re enable and save. What table is it that you deleted?

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [February 21, 2013, 6:12pm UTC](https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904/3 "2013-02-21T18:12:29Z")

</div>

the sql\_data\_with the date on the end??

Ive tried disabling and re-enabling the tag history provider but it doesnt seem to do anything. ive even tried stopping and starting the gateway. I do notice that the sqlth\_partitions table still lists the old tablename. should I delete it from that table?

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [February 21, 2013, 6:37pm UTC](https://forum.inductiveautomation.com/t/accidentally-deleted-tag-history-table/5904/4 "2013-02-21T18:37:08Z")

</div>

Hi,

Yeah, try removing the row for the latest partition table. The data table should get created the first time the system attempts to store data, but perhaps the entry in that table is throwing it off.

Regards,