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
- 295 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
Strange behavior of native restore
ta5
Member Posts: 1,164
Hello
I noticed a strange behavior of the native restore, version 5.0, sp0 and sp1.
Backup:
The backup was taken from a database containing 10 companies, including objects and the data for all companies, but only 1 company was selected for the backup.
Restore:
A new db is created, restore is started for the backuped company, with the option data for all companies, including objects.
Error:
After a while following error is thrown: "Company xy" not found. The company xy is the first one in the original db but it has intentionally not been backuped. I guess the problem occurs while restoring the security tables, because some roles point to a company that does not exist.
Question:
What are the proper steps to get a backup of only one company into an empty db? Backing up all companies is not an option because the companies are huge. IMHO this was not a problem until 5.x.
Thanks in advance
Thomas
I noticed a strange behavior of the native restore, version 5.0, sp0 and sp1.
Backup:
The backup was taken from a database containing 10 companies, including objects and the data for all companies, but only 1 company was selected for the backup.
Restore:
A new db is created, restore is started for the backuped company, with the option data for all companies, including objects.
Error:
After a while following error is thrown: "Company xy" not found. The company xy is the first one in the original db but it has intentionally not been backuped. I guess the problem occurs while restoring the security tables, because some roles point to a company that does not exist.
Question:
What are the proper steps to get a backup of only one company into an empty db? Backing up all companies is not an option because the companies are huge. IMHO this was not a problem until 5.x.
Thanks in advance
Thomas
0
Answers
i think Malajlo wants to mean "Create a new company with no data"
so far, so good
If you backup just one company and try to restore it, it will fail because it tries to restore the others as well...
Have just tried doing a backup of one company from a database containing two and restoring just one using build No. 24652, and this worked OK...
Lead Consultant
Theta
Backup was done with Build 24199 (CH, 5.0 SP0)
Restore was done with Build 26084 (CH, 5.0 SP1), maybe this was the cause of problem...
Restoring in the following order did the trick: Objects, Data common to all companies, company.
Thanks for all your help.
Thomas
Thanks
Karen