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)
0
Comments
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
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)
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n