# \[SOLVED\]Can't recreate database: SQL logic error or missing database no such table: LogData

**URL:** <https://forum.duplicati.com/t/solved-cant-recreate-database-sql-logic-error-or-missing-database-no-such-table-logdata/8476>\
**Category:** Support\
**Created:** [November 16, 2019, 12:48pm UTC](https://forum.duplicati.com/t/solved-cant-recreate-database-sql-logic-error-or-missing-database-no-such-table-logdata/8476 "2019-11-16T12:48:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![canove](https://forum.duplicati.com/user_avatar/forum.duplicati.com/canove/32/177_2.png) [@canove](https://forum.duplicati.com/u/canove)\
**Post date:** [November 16, 2019, 12:48pm UTC](https://forum.duplicati.com/t/solved-cant-recreate-database-sql-logic-error-or-missing-database-no-such-table-logdata/8476/1 "2019-11-16T12:48:42Z")

</div>

I’m trying to recreate a database from a 20GB backup to restore files on a different computer. I Just installed Duplicati and import the configuration file. When I hit “recreate database” it gives an error:

 ![image](https://forum.duplicati.com/uploads/default/original/2X/9/95a25fdeae681afd43d38ecb5295917fdf82e4ac.png)

A 0KB database is created on Duplicati’s folder:

 ![image](https://forum.duplicati.com/uploads/default/original/2X/e/ea948a348182a47edc45b37167ff6bac0fcff7e4.png)

Any help will be appreciated.

Thanks

---

<div class="post-metadata">

**Author:** ![canove](https://forum.duplicati.com/user_avatar/forum.duplicati.com/canove/32/177_2.png) [@canove](https://forum.duplicati.com/u/canove)\
**Post date:** [November 16, 2019, 12:53pm UTC](https://forum.duplicati.com/t/solved-cant-recreate-database-sql-logic-error-or-missing-database-no-such-table-logdata/8476/2 "2019-11-16T12:53:14Z")

</div>

I am sorry! It was a “run-before” script on my advanced configuration, that the patch doesn’t exist on this new computer. Removed this advanced option and recreation just worked!

Maybe Duplicati should handle it with a better error message?

Thanks!

---

<div class="post-metadata">

**Author:** ![drwtsn32](https://forum.duplicati.com/user_avatar/forum.duplicati.com/drwtsn32/32/2591_2.png) [@drwtsn32](https://forum.duplicati.com/u/drwtsn32)\
**Post date:** [November 21, 2019, 5:09am UTC](https://forum.duplicati.com/t/solved-cant-recreate-database-sql-logic-error-or-missing-database-no-such-table-logdata/8476/3 "2019-11-21T05:09:33Z")

</div>

Yes - I agree the error could be reported better! Thank you for following up and sharing what you found with the forum.