# Initial backup stuck at 100%

**URL:** https://forum.duplicati.com/t/initial-backup-stuck-at-100/10767
**Category:** Support
**Created:** [September 18, 2020, 4:13pm UTC](https://forum.duplicati.com/t/initial-backup-stuck-at-100/10767 "2020-09-18T16:13:43Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![projeculatort](https://forum.duplicati.com/letter_avatar_proxy/v4/letter/p/53a042/32.png) [@projeculatort](https://forum.duplicati.com/u/projeculatort)
#### Post date: [September 18, 2020, 8:18pm UTC](https://forum.duplicati.com/t/initial-backup-stuck-at-100/10767/4 "2020-09-18T20:18:10Z")

</div>

I ended up killing Duplicati since it seemed unlikely to finish. I tested running [`ANALYZE`](https://sqlite.org/lang_analyze.html) on the database and the query went from hanging indefinitely to completing in seconds. Doing this changed the query plan from `SCAN` to `SEARCH`.

I see that Duplicati is already using `PRAGMA optimize`:

> <https://github.com/duplicati/duplicati/blob/174edf422ec828cf0802366470c9e39ad2293930/Duplicati/Library/Main/Database/LocalDatabase.cs#L1379>

Maybe this needs the chance to run earlier?

After restarting Duplicati, it verified successfully and did not need to reupload any data.

---

_[View the full topic](https://forum.duplicati.com/t/initial-backup-stuck-at-100/10767)._