Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 309 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
- 260 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
keys inactivated
rsummers
Member Posts: 9
Has anyone had a issue when restoring a Navision backup into SQL after the backup is restored all the secondary keys are inactive. I have seen this in a couple of instances and do not know what it causing it. Any help??
0
Comments
Maybe your DB space is also a problem and SQL.
Solution: Increase DB space and continue with the DB restore as if you had not started it yet. It will continue where it had stopped on the last Table where the active keys had all been build and committed. After all the tables' keys had been build it will ask you where the backup is to restore, cancel here & go back to the complete restored DB.
If the above does not resolve your problem, then go to DB Info, Tables and Select All and click on Optimize, which will rebuild all active keys.