SQL 2005 and Navision 4.02 restore error

Sorcerer

Hello everyone,

i've got a new problem while converting our database from 3.70 to 4.00 sp2. when i try to restore a native backup of one company to the sql server 2005 with navision 4.00 sp2 (build 22611) the jobs runs about 8 to 12 hours before the followin error occurs:

"the server is not reachable. there is propably a connection error. try to open the database ba file, database, open..."

the restore is then rolled back in the sql server.
several other restore with the same configuration has already been restored fine. but this is the biggest company (about 60 gb).

Information about system configuration:
sql server 2005 enterprise x64 sp1 (7 GB RAM)
navision 4.00 sp2 build 22611
server: fujitsu primergy rx600 s2 with 4 xeon 7040 with 16 GB RAM
os: windows 2003 r2 enterprise x64 (clustered)

ara3n

Have you tried to run the client on the server and connect to the server directly? and then restore?

Sorcerer

that is the way i done it.

but i've got a workaround now.

you can restore the sql 2000 backup into 2005, set it to mode 9.0 and rename the Objekt table to Object. The column Typ to Type an set this in the database property table. then a conversion of the database is possible with the 4.00 Sp 2 client. (after deleting all users exept one superuser) tested with our german database.

the restore with a native backup seems to crash because of the hugh file size. (hope this will change in sp3)

ara3n

Thanks for the info. I'm worried. Our clients db are growing day by day and navision is reaching the limits of capabilites on some processes. Such as backup and restore, Running adjust cost. Reservation, SIFT tables.