# Elastic GravityApps Sql Backup Transaction Logs

**URL:** <https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494>\
**Category:** Elasticsearch\
**Created:** [April 4, 2022, 10:36am UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494 "2022-04-04T10:36:02Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Techplay27](https://avatars.discourse-cdn.com/v4/letter/t/b487fb/32.png) [@Techplay27](https://discuss.elastic.co/u/Techplay27)\
**Post date:** [April 4, 2022, 10:36am UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494/1 "2022-04-04T10:36:02Z")

</div>

I can see quite a few transaction logs dating back to last year June and this is really using a lot of disk space up. I have a scheduled a full backup of the server, so after this successfully completes I will delete all last years logs.

As best practice what length of time should the transaction logs be kept on the server?

 ![SQLBackups](https://us1.discourse-cdn.com/elastic/original/3X/d/8/d8f0cc7cf1b2bbb7d2e07ce155fac76771d9871a.jpeg)

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 4, 2022, 10:51pm UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494/2 "2022-04-04T22:51:43Z")

</div>

Welcome to our community! 😃

Elasticsearch doesn't create these, so you'd need to ask your sql server admin.

---

<div class="post-metadata">

**Author:** ![Techplay27](https://avatars.discourse-cdn.com/v4/letter/t/b487fb/32.png) [@Techplay27](https://discuss.elastic.co/u/Techplay27)\
**Post date:** [April 6, 2022, 9:16am UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494/3 "2022-04-06T09:16:58Z")

</div>

I get that, I am the system admin, all previous left so now got to work it out for myself, isn't how most of us sys admins start out, learning after other seniors leave? haha!

Transaction logs backup each day 30mins apart and then a full backup is run every night, so I'd say I am safe deleting older backups as there have not been any issues since that time, so really as long as I keep at least two/three weeks worth, should be fine.....right? 🙂

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [April 6, 2022, 10:44pm UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494/4 "2022-04-06T22:44:30Z")

</div>

What you're asking is outside the scope of what we can assist with as Elasticsearch is not the product you are asking about.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [May 4, 2022, 10:44pm UTC](https://discuss.elastic.co/t/elastic-gravityapps-sql-backup-transaction-logs/301494/5 "2022-05-04T22:44:41Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.