Navision Company Data Restore Error

Jonathan2708
Member Posts: 552
Hi,
I'm trying to restore a company only data backup to another database with the same set of objects. The restore gets right to the end then gives the following error :
'Restore has been terminated because data common to all companies exists in the database.'
The backup file was created by simply selecting 1 company from the list. The 'Data Common To All Companies' and 'Application Objects' options were both left unticked.
Never seen this error before. It's Navision SQL version 4.00SP3 client with 4.00SP1 objects.
Any help appreciated,
Jonathan
I'm trying to restore a company only data backup to another database with the same set of objects. The restore gets right to the end then gives the following error :
'Restore has been terminated because data common to all companies exists in the database.'
The backup file was created by simply selecting 1 company from the list. The 'Data Common To All Companies' and 'Application Objects' options were both left unticked.
Never seen this error before. It's Navision SQL version 4.00SP3 client with 4.00SP1 objects.
Any help appreciated,
Jonathan
0
Comments
-
Have you tried creating a new empty database and restoring your backup to it?
I ran into that problem on one occasion and it worked for me.
Before I did that I tried doing a restore with and without objects which sometimes worked.Half-empy or half-full how do you view your database?
Thanks.0 -
Restore data into blank database, backup again without common data (and objects!) and restore it again.0
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
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions