Navision 4.0 with MS Sql Server 2000

Ashok_Kumar_Sharma

Hi !

Can any one help me. I am using Navision 4.0 with SQL Server 200 Database. Yesterday, I have taken backup from Navision which created xxx.fbk file. Later I created a blank Database and tried to restore the back from xxx.fbk file. I received the following message - "TableData 27 Does not exits" and system terminated. Later I opened my database and brows Table 27 in Object browser - all data is there. I tested the whole database and found no error.

I created a blank database in Native Navision and tried to resotre the backup from the same xxx.fbk file. It went smoothly. On Checking I found that Table 27 have no data.

I would be greatful if any one can help me in solving this problem.

Thanks,

A.K. Sharma

garak

Did you have changed the property DataperCompany on table 27?
Is this ever, or only in this one case?

Tip: if you need the database as copy on the server, it's easier and faster to create a sql backup and restore this sql backup as new database on the server.

Administrator

[Topic moved from NAV Tips & Tricks to NAV/Navision forum]

kriki

Luc, I think you were already sleeping

[Topic moved from 'Navision Attain' forum to 'NAV/Navision' forum]

Ashok_Kumar_Sharma

kriki wrote:

Luc, I think you were already sleeping

[Topic moved from 'Navision Attain' forum to 'NAV/Navision' forum]

Hi !

Sorry ! I was away from my Office. Many-2 thanks for responding. Unfortunately I could
not get the right solution.

Thanks & Regards,

Ashok_Kumar_Sharma

garak wrote:

Did you have changed the property DataperCompany on table 27?
Is this ever, or only in this one case?

Tip: if you need the database as copy on the server, it's easier and faster to create a sql backup and restore this sql backup as new database on the server.

Hi !
Thanks for rsponding. I am sorry for late as I was away from may Office.
No I did not change any property of Table 27.

Thanks & Regards,