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
- 310 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
Restore incomplete
Karenh
Member Posts: 209
Using SQL Server 2008, we cannot get restore to restore objects (other than tables) and data common to all companies.
I was able to create a company, restore Cronus from backup, and everything worked perfectly.
But not so with the live db. There is no error message, only the usual message about the restore being completed.
I can export/import objects as a workaround but we need to be able to restore objects also.
I have backed up the transaction log, so there is plenty of space there. I am logging in as sa, so permissions are not the problem.
I would appreciate any suggestions.
I was able to create a company, restore Cronus from backup, and everything worked perfectly.
But not so with the live db. There is no error message, only the usual message about the restore being completed.
I can export/import objects as a workaround but we need to be able to restore objects also.
I have backed up the transaction log, so there is plenty of space there. I am logging in as sa, so permissions are not the problem.
I would appreciate any suggestions.
0
Comments
This means that there are already objects in the database. To do a full restore you need a clean empty database. So start with FILE DATABASE NEW
If you create company first, the database is not empty anymore, thus you cannot restore objects and data common to all companies...
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.