Database restore process does not create keys

gvolkov

Hello All!

This has happened to me before, but i simply went to Tools, Restore and keys were created. Now, the backup restore restores the data, but keys arent created. Even if i go to Tools, Restore, it does not prompt to continue.

(NAV6.1 client with 4.2 database)

kriki

Do you have table-objects (WITH indexes) in your DB?

hardik_shah

Same problem happen to me.I just delete old one and Recreate new database and restore again...

gvolkov

kriki wrote:

Do you have table-objects (WITH indexes) in your DB?

indexes are there, they are just not enabled.

David_Singleton

gvolkov wrote:

kriki wrote:

Do you have table-objects (WITH indexes) in your DB?

indexes are there, they are just not enabled.

Just export the tables fro a good DB and import them into this DB. That ill force a rebuild of the indexes as required.

Don't manually activate the keys, A/ it will take too long, but B/ some keys are probably supposed to be inactive.