Restore company error in SQL server 2003!

cunny

Hey guys,

I have encountered a critical problem when I try to restore a company to SQL server 2003. The backup file which came from this server just contains compay data without objects .When I tried to restore it there is a pop error message from SQL server 2003 and it showed me that "The following SQL Server error(s) occurred while accesing the Payment Terms table:15333,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]error: The qualified @oldname refrences a database(XXX) other than the current database.",

Any idear,please kindly let me know.

Thanks &Good Luck,

ara3n

Make sure the database Name you've selected is in correct CASE.
Instead of typing it, do a lookup and select the database when you login into navision.

cunny

Thank you very much ara3n!

But I do select the database and the company when I login. It seems that the same error will also pop up when I change a company name in the database! Have you encountered this one!

Thanls &Good Luck,

ara3n

Make sure the Server name, and database in the same case. When you rename company, the database name is case sensetive.

Go to file->database->Open.
Hit F6 on server name and select your server.
Type your login and password.
Lookup on Database Name and select your database.
Then click ok. Now restore your db.


mydatabase is not the same as MyDatabase.

cunny

Hi there,

Sorry for my rash error description.This error is occuring when the process of restoring company is all most complete.When the message pup up the whole process was aborted. Any idear for this. I am totally confused :?

Thanks,