# Data of SQL

**URL:** <https://forum.getodk.org/t/data-of-sql/23535>\
**Category:** Support\
**Tags:** odk-aggregate\
**Created:** [November 26, 2019, 12:58pm UTC](https://forum.getodk.org/t/data-of-sql/23535 "2019-11-26T12:58:09Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bharat\_Sharma](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/bharat_sharma/32/8203_2.png) [@Bharat\_Sharma](https://forum.getodk.org/u/Bharat_Sharma)\
**Post date:** [November 26, 2019, 12:58pm UTC](https://forum.getodk.org/t/data-of-sql/23535/1 "2019-11-26T12:58:09Z")

</div>

Hi, I am using my own server with Sql as database.  
I want to know when I delete data froom ODK aggregare, it also deletes data from Sql or it stays inside it.  
And I have not created any table in Sql, in which table the data is storing?

Thank you.

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [November 26, 2019, 2:01pm UTC](https://forum.getodk.org/t/data-of-sql/23535/2 "2019-11-26T14:01:28Z")

</div>

Hi, @Bharat_Sharma!

Aggregate will delete data from your database. The data structure is described here: [https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure](https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure)

---

<div class="post-metadata">

**Author:** ![Joaquin\_Linares](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/joaquin_linares/32/12720_2.png) [@Joaquin\_Linares](https://forum.getodk.org/u/Joaquin_Linares)\
**Post date:** [November 26, 2019, 3:15pm UTC](https://forum.getodk.org/t/data-of-sql/23535/3 "2019-11-26T15:15:29Z")

</div>

Si miras, cada formulario no contiene este prefijo \_ podrías crear una copia de las tablas que el formulario crea y luego eliminar así no pierdes los datos.

---

<div class="post-metadata">

**Author:** ![Bharat\_Sharma](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/bharat_sharma/32/8203_2.png) [@Bharat\_Sharma](https://forum.getodk.org/u/Bharat_Sharma)\
**Post date:** [November 28, 2019, 4:06am UTC](https://forum.getodk.org/t/data-of-sql/23535/4 "2019-11-28T04:06:46Z")

</div>

Hi, if you can explain more on this.  
And thanks for the suggestion.

---

<div class="post-metadata">

**Author:** ![Bharat\_Sharma](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/bharat_sharma/32/8203_2.png) [@Bharat\_Sharma](https://forum.getodk.org/u/Bharat_Sharma)\
**Post date:** [November 28, 2019, 4:10am UTC](https://forum.getodk.org/t/data-of-sql/23535/5 "2019-11-28T04:10:47Z")

</div>

Hi, thanks for the valuable response. How I can keep data safe in database. If I delete the data from Aggregate.

---

<div class="post-metadata">

**Author:** ![ggalmazor](https://getodk.b-cdn.net/user_avatar/forum.getodk.org/ggalmazor/32/2702_2.png) [@ggalmazor](https://forum.getodk.org/u/ggalmazor)\
**Post date:** [November 28, 2019, 8:48am UTC](https://forum.getodk.org/t/data-of-sql/23535/6 "2019-11-28T08:48:35Z")

</div>

> How I can keep data safe in database. If I delete the data from Aggregate.

You should backup your database. The process varies depending on the database server you're using and your server's platforms. There's a docs page explaining what to do at [https://docs.opendatakit.org/aggregate-backup/](https://docs.opendatakit.org/aggregate-backup/)