Hi I am tryinng to import a back up file which contains more than one company. I want to restore only one company from the back up file. So i do the normal procedure and select the company i want to restore n start the process. …and suddenly after creating some keys…the system throws out an error ’ The company XXX is already exisitng’…infact the company is not there before resrtoration…i can see the company being created …but no data in it…this is SQL option and the error occurs on the server…on the other hand everything is ok when i do the restoration on a client… cheers
Did you create new database before restore?
I found this happening under the following condition:
Run a client and connect to a nvaision database.
Do the same on a second machine (connect to the same database and open the same company).
Delete the company on one machine and don’t do anything on the second client.
Start the restauration process and while doing this just continue working on the other client.
Any write transaction will recreate the previously deleted company and therefore cause the restauration process on the other client to fail !!!
That’s why Navision always gave the advise that all users should be out of the system when restoring backups.