Creation of virtual tables while restoring a company

mohit0989

Hello every one
I took the backup of abc company from XYZ database.Then i made a new company abc1 in XYZ database and restored the abc company on it.Now the problem rises, ](*,) it has made a new series of virtual table from 1000050002 and made a copy of all the existing tables.i have no idea why this happened,how this happened as i don't have license to run these virtual tables.Shred some light.Thanks!!:)

kriki

[Topic moved from 'NAV Tips & Tricks' forum to 'NAV/Navision Classic Client' forum]

It means your restore has been interupted. Restart a restore and NAV will ask you if you want to finish the restore or remove it.

mohit0989

yes the restore has been interrupted and when i restarts it ask if you want to finish the restore or remove it.then when you try to finish it shows an error in table 1000050002 some value is not null.but you can't run that table either.So what to do??

kriki

You probably opened the company while it was still restoring. Opening a company creates some records in some tables.
The only thing you can do is to cancel the restore and restart the restore from scratch.

mohit0989

thanks Kriki for your reply :thumbsup: ,but problem is something else,i restored the it again from starting but still the same error #-o so i guess i need to make a new company in a new database ](*,) .i just wanted to know why it happened.anyways thanks you

kriki

Give this a try: create a new database and try to restore the backup immediately after creating the new DB.