# Unable to restore DB

**URL:** <https://www.dynamicsuser.net/t/unable-to-restore-db/10319>\
**Category:** Developers Forum\
**Created:** [October 18, 2005, 3:04pm UTC](https://www.dynamicsuser.net/t/unable-to-restore-db/10319 "2005-10-18T15:04:04Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![rosine](https://avatars.discourse-cdn.com/v4/letter/r/f4b2a3/32.png) [@rosine](https://www.dynamicsuser.net/u/rosine)\
**Post date:** [October 18, 2005, 3:04pm UTC](https://www.dynamicsuser.net/t/unable-to-restore-db/10319/1 "2005-10-18T15:04:04Z")

</div>

HI all! When I try to restore an SQL database on my desktop, this is the message that I get: --------------------------- Microsoft Business Solutions-Navision --------------------------- You cannot delete or change the type of the Aircraft Registration field (in the Job table) before the value in the field is reduced to 0 (zero) or ‘’ (blank) in all records. This message occurred because a nonzero value was found for the record No.=‘2003E024’ in company ABCD inc… --------------------------- OK --------------------------- What can be the problem? Hoe can I solve it? Thanks for help.

---

<div class="post-metadata">

**Author:** ![rosine](https://avatars.discourse-cdn.com/v4/letter/r/f4b2a3/32.png) [@rosine](https://www.dynamicsuser.net/u/rosine)\
**Post date:** [October 18, 2005, 4:41pm UTC](https://www.dynamicsuser.net/t/unable-to-restore-db/10319/2 "2005-10-18T16:41:59Z")

</div>

Ok guys! i just solved it. In fact, I forgot to restore in a new DB…[:(!]
