Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K 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
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 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
Options
How to retrieve lost data due to incorrect database restore
kelseykong@hotmail.com
Member Posts: 86
Dear expert
One of our engineers took a backup from production, did a posting in production, and then restored the backup that he took before. The total process is around one hour. However, unfortunately users posted transactions during that time frame and the transactions are overwritten by the restoration of backup.
May I know if there is any way to find out which data has been posted during that time frame? Which will be the best way to handle this issue?
Thank you.
Li
One of our engineers took a backup from production, did a posting in production, and then restored the backup that he took before. The total process is around one hour. However, unfortunately users posted transactions during that time frame and the transactions are overwritten by the restoration of backup.
May I know if there is any way to find out which data has been posted during that time frame? Which will be the best way to handle this issue?
Thank you.
Li
0
Comments
I don't think they know what information was lost, I think that is what he is asking, that what is a method for finding lost information.
I don't think a general method exists, but as this is not typically a Navision problem perhaps there exists a general procedure for accounting systems in general if you look around online. I would look at each application area and make a strategy for each. For sales I would compare the past printed invoices or shipments with the booked ones. For purchase invoices and purchase orders just go to the last booked ones and go on booking as long as you can find unbooked papers. But I have no idea about stuff like master data like customers, I don't think there is a way to remember what was changed...