Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 298 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to delete corrupted records only in a table ?
smmurugan
Member Posts: 33
Hi friends,
We had a crash of NAV native DB when we were trying to expand the DB by 10 GB. (was expanded from 45 GB to 55 GB)
Somehow we were able to open the database working fine for the end user. Since then we are not able to take navision inbuilt back up of the DB saying DB is corrupted. After close analysis we found the table corrupted also the records corrupted. We are able access other records except corrupted records.
I am planning to clean table as below:
1. Export all the records in a text file which are not corrupted
2. Delete the all the records in the table.
3. Import the exported data which are clean
My concern is this table is containing millions of records, Exporting / deleting / reimporting takes time and down time will be more.
Is there any way I can delete only the corrupted records on the table directly or through code.
I tried as below :
1. In the table filter the records. Afftected record entry no. range is 41..81 . I even tried 35..85.
2. Same I tried through code also.
In Both the scenarios got the message 'corrupted'.
Can any one suggest best way to minimise down time ?
Thanks
Murugan
We had a crash of NAV native DB when we were trying to expand the DB by 10 GB. (was expanded from 45 GB to 55 GB)
Somehow we were able to open the database working fine for the end user. Since then we are not able to take navision inbuilt back up of the DB saying DB is corrupted. After close analysis we found the table corrupted also the records corrupted. We are able access other records except corrupted records.
I am planning to clean table as below:
1. Export all the records in a text file which are not corrupted
2. Delete the all the records in the table.
3. Import the exported data which are clean
My concern is this table is containing millions of records, Exporting / deleting / reimporting takes time and down time will be more.
Is there any way I can delete only the corrupted records on the table directly or through code.
I tried as below :
1. In the table filter the records. Afftected record entry no. range is 41..81 . I even tried 35..85.
2. Same I tried through code also.
In Both the scenarios got the message 'corrupted'.
Can any one suggest best way to minimise down time ?
Thanks
Murugan
0
Comments
- Create a new table, as a copy of the corrupted table
- Copy the records from the corrupted table to the new table, from the first until (not including) the first corrupted record
- Copy the records from the corrupted table to the new table, from the last up until (not including) the last corrupted record
- DELETEALL from the corrupted table. Don't fire the trigger!
- I removed and recreated the object, but that may be optional
- Copy all the records from the new table back to the once corrupted table
In my case I had 3 tables with only 1 corrupted record each, and was able to restore all the non-corrupted records this way. I don't know if it is possible to recover records between corrupted records. It wouldn't surprise me if you can't.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!