Sqlserver 2000 Restore Problem

Hi! we have Navision Attain 3.60 with its own database on a windows 2000 server running (32 GB database). I want to install on a test server my Navision 3.60 database with a sqlserver 2000 database. The sqlserver databse is on an other windows 2000 server. So I made a complete backup of my navision own database. Then I start on my test server the navision sql client and make a restore on a second test sql server 2000. The restore runs long time very well but it stops after some time with the following error message. ‘Field Number 1 is in table xy not defined’. I took a look to the definition of that table in my navision own database. There is really no field number 1 in that table. Must I have a field number 1 for the restore on a sqlserver 2000? How could I make in my case a sucessfull restore on a sqlserver 2000? What are the steps for a restore on a sqlserver 2000? Must I take sqlserver users or is it also possible with windows users? I make all with the sa user. Thanks!

It looks like you forgot to import the objects. I generally do a SQL restore in two steps. 1/ Import objects and Common FIles 2/ Import Data. Best at this time is to start with a new SQL database. Do a complete backup of you Navision DB, and resotre it one step at a time. By the way which table is giving the error?

quote:


Originally posted by David Singleton
It looks like you forgot to import the objects. I generally do a SQL restore in two steps. 1/ Import objects and Common FIles 2/ Import Data. Best at this time is to start with a new SQL database. Do a complete backup of you Navision DB, and resotre it one step at a time. By the way which table is giving the error?


Isn’t it a lot more easy to use the backup-restore procedures of SQL server itself ? Just do a full backup with SQL server, and take this backup to restore it on the second server (perhaps with a different database name) Didn’t have any problems so far with this method, and the keys do not have to be recalculated again.

Moved from Developer Forum to Technical Forum.

quote:


Originally posted by steurm
Isn’t it a lot more easy to use the backup-restore procedures of SQL server itself ? Just do a full backup with SQL server, and take this backup to restore it on the second server (perhaps with a different database name) Didn’t have any problems so far with this method, and the keys do not have to be recalculated again.


He is doing a conversion from C/Side to SQL, so how can he make a SQL backup?