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
- 296 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
Need to move transactons from one Db to another.
Denis_Petrov
Member Posts: 107
We had a hard drive failure (at the time when RAID was disabled :x
Database has been restored to another (TEMP) server but one day of transactions is lost. We do have a read only access to our old database (located on the MAIN server) but with the following message:
Microsoft Business Solutions-Navision
There is a corrupted area in the database. This type of error occurs if the database file is changed by another program or if the device driver does not function correctly.Warning! This error MUST be corrected before you can continue. Do not use any type of disk utilities on the database.First check the database by clicking File, Database, Test and then click Maximum. If you still get the same error, you should:1) Make a backup of the database by copying the database file(s).2) Use the built-in function to make a backup.3) If this works, create a new database WITHOUT deleting the database that contains the error(s).Restore the backup (made with the built-in backup function) into the new database, and test it by clicking File, Database, Test and then clicking Maximum.If this procedure does not work, any changes to the database after the most recent backup will be lost. Restore the most recent backup (made with the built-in backup function) and test it.For security reasons, you should save the old database until you have used the new one for a period of time.Contact your system manager if you need assistance.
OK
So the questions are:
1 Is there any way to fix the corrupted database? ( I tried the back up - comes back with the same error message as above)
2 If we can not restore the corrupted database what would the be right approach to extract those (missing from backup) transactions and move them into the new (restored from the backup) database? They all have a posted date of 10/27/2008.
Thank you very much
Denis Petrov
Database has been restored to another (TEMP) server but one day of transactions is lost. We do have a read only access to our old database (located on the MAIN server) but with the following message:
Microsoft Business Solutions-Navision
There is a corrupted area in the database. This type of error occurs if the database file is changed by another program or if the device driver does not function correctly.Warning! This error MUST be corrected before you can continue. Do not use any type of disk utilities on the database.First check the database by clicking File, Database, Test and then click Maximum. If you still get the same error, you should:1) Make a backup of the database by copying the database file(s).2) Use the built-in function to make a backup.3) If this works, create a new database WITHOUT deleting the database that contains the error(s).Restore the backup (made with the built-in backup function) into the new database, and test it by clicking File, Database, Test and then clicking Maximum.If this procedure does not work, any changes to the database after the most recent backup will be lost. Restore the most recent backup (made with the built-in backup function) and test it.For security reasons, you should save the old database until you have used the new one for a period of time.Contact your system manager if you need assistance.
OK
So the questions are:
1 Is there any way to fix the corrupted database? ( I tried the back up - comes back with the same error message as above)
2 If we can not restore the corrupted database what would the be right approach to extract those (missing from backup) transactions and move them into the new (restored from the backup) database? They all have a posted date of 10/27/2008.
Thank you very much
Denis Petrov
Best regards,
Denis Petrov.
Denis Petrov.
0
Comments
You need to contact your partner, they will contact Microsoft, and probably you will need to send the database to Microsoft and they will do the extraction. They wont normally let the product out of the building unfortunately.
I have used this in the past to recover quite a lot of valuable data.
C/DART - Dynamics