database restore to SQL - field is not defined in table

DoomhammerDoomhammer Member Posts: 211
Hi,

I have problem with database restore from native to SQL server.
database and client are 5.0 SP1, client is newest build. SQL is 2012.

During restore process, I am running into problem: error message Field No ### is not defined in the ### table.

I tried to recompile all objects, deleted objects with compilation error, but did not help.

Thanks for help.
Martin Bokůvka, AxiomProvis

Best Answer

  • DoomhammerDoomhammer Member Posts: 211
    Answer ✓
    Hello,

    I found my problem - someone deleted two fields in table and those fields were used in keys. I deleted those keys and restore was OK.
    this error could not be found via compile.
    Martin Bokůvka, AxiomProvis

Answers

  • evandeveerdonkevandeveerdonk Member Posts: 49
    Hi Martin,

    are you able to do an import of the objects first? Either by importing a fob, or a backup with only the objects.
    In that case, you might by-pass this problem
    Ernst
    http://www.vssolutions NAV-Outlook synchronisation re-invented.
  • DoomhammerDoomhammer Member Posts: 211
    Answer ✓
    Hello,

    I found my problem - someone deleted two fields in table and those fields were used in keys. I deleted those keys and restore was OK.
    this error could not be found via compile.
    Martin Bokůvka, AxiomProvis
Sign In or Register to comment.