# Backup details using SQL queries

**URL:** <https://community.cratedb.com/t/backup-details-using-sql-queries/1572>\
**Category:** CrateDB\
**Created:** [August 25, 2023, 7:37am UTC](https://community.cratedb.com/t/backup-details-using-sql-queries/1572 "2023-08-25T07:37:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vinayak\_Katkar](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/vinayak_katkar/32/837_2.png) [@Vinayak\_Katkar](https://community.cratedb.com/u/Vinayak_Katkar)\
**Post date:** [August 25, 2023, 7:37am UTC](https://community.cratedb.com/t/backup-details-using-sql-queries/1572/1 "2023-08-25T07:37:42Z")

</div>

Hi Team,

We are taking automatic backups every day, using Python scripts.  
Backup is done successfully every day. But that backup is not showing on SYS.SNAPSHOTS.

Any other way we can get to know that, backup is done using query in Cratedb.

Thanks  
Vinayak Katkar

---

<div class="post-metadata">

**Author:** ![hernanc](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/hernanc/32/676_2.png) [@hernanc](https://community.cratedb.com/u/hernanc)\
**Post date:** [August 25, 2023, 10:37am UTC](https://community.cratedb.com/t/backup-details-using-sql-queries/1572/2 "2023-08-25T10:37:57Z")

</div>

Hi,  
When you query `sys.snapshots` CrateDB actually checks the repository, so if a snapshot is not listed there may be a problem with the repository.  
I would advise you try to restore one of these snapshots and try taking snapshots against a new repository.

---

<div class="post-metadata">

**Author:** ![Vinayak\_Katkar](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/vinayak_katkar/32/837_2.png) [@Vinayak\_Katkar](https://community.cratedb.com/u/Vinayak_Katkar)\
**Post date:** [August 28, 2023, 6:14am UTC](https://community.cratedb.com/t/backup-details-using-sql-queries/1572/3 "2023-08-28T06:14:33Z")

</div>

Ok noted.  
We check that one.  
Thanks
