Database Corruption in 3.1 on Table Sales Invoice Line

Subbu
Subbu Member Posts: 2
edited 2005-05-27 in Navision Attain
Hi,

Can anyone help me to recover the data from the below problem

As soon as i login it says there was a corrupted area in the database and do test and all.

I found there is a problem in the Sales Invoice line table. I am not able to do backup also, i am not able to restore the old backup which was taken recently and it restores to 100% and it says the backup file not found.

Also am trying to delete all the table record of Sales Invoice line table ,its not deleting and the database size keep on increasing as i increasing and it reaches 100%. If i add more ,in 5 mins it increases to 100%.

Is there any way out to delete the records Sales line table and take backup and restore the same. Backup is not generating due to sales line table.

Comments

  • kine
    kine Member Posts: 12,562
    In which way you are deleting the records?
    Can you open the table and copy all records for example into Excel?

    Another way is to transfer all other tables into new DB, but this is a big amount of data...

    May be you will be able to delete the data through C/ODBC...

    !!!Before any attempt to save the data, copy the DB file to some backup place...!!! One open of the database with some write operation can destroy your last chance to restore the data!!!

    If you have corrupted DB, there is tool called C/DART, but this tool have only Microsoft and you must pay for this service...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.

Categories