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
- 304 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
Nav 2013 trying to restore Cronus from fbk to new database
daek
Member Posts: 4
Hello,
Long time reader - first time poster.
I have recently installed Dynamics NAV 2013 in a three tier solution.
The database is installed on a Microsoft SQL 2008 R2 dedicated server
And the Application Server is installed on a Microsoft Server 2008 R2
I have followed the steps on this link: http://msdn.microsoft.com/en-us/library ... 70%29.aspx
however I have not installed the demo database.
In prevous versions (6,0) I create a database using Classic Client with SQL and then restore Cronus from database.fbk located in the installation media.
Now I'm trying to do the same thing with Nav 2013 Preview however i get the following error (translated by me from Swedish to English):
Waring: An errorr has occurred in the database structure. This occurres if the database file is modified by another software or if a device driver is not functioning correctly.
You have to fix this error before you can continue. Error (1213 in module 19) may have been caused by the computer or a software.
How can I restore the Cronus company to my new Dynamics NAV 2013 database?
Long time reader - first time poster.
I have recently installed Dynamics NAV 2013 in a three tier solution.
The database is installed on a Microsoft SQL 2008 R2 dedicated server
And the Application Server is installed on a Microsoft Server 2008 R2
I have followed the steps on this link: http://msdn.microsoft.com/en-us/library ... 70%29.aspx
however I have not installed the demo database.
In prevous versions (6,0) I create a database using Classic Client with SQL and then restore Cronus from database.fbk located in the installation media.
Now I'm trying to do the same thing with Nav 2013 Preview however i get the following error (translated by me from Swedish to English):
Waring: An errorr has occurred in the database structure. This occurres if the database file is modified by another software or if a device driver is not functioning correctly.
You have to fix this error before you can continue. Error (1213 in module 19) may have been caused by the computer or a software.
How can I restore the Cronus company to my new Dynamics NAV 2013 database?
0
Comments
how do you try to restore the database?
Create a new DB from NAV2013 Dev Env.?
Regards,
egnaz
Yes, exactly. I create the new DB from Dev Env and it is correctly writing to my SQL-server however when I try to restore the Cronus company from database.fbk (located at installation disk) I get the above error.
Located at: \SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\70\Database\
Yes i tried it, but I would like to restore it to my newly created database.
The *.bak file restores the original database "Demo Database NAV (7-0)" to SQL but I want the data to be inserted to my own, since I have installed instaces/services/accounts to this...
In your created DB is something (field structure) different from the org. 2013 DB so it's not possible to restore.
I think there are 2 options:
- figure out which table, etc. must be changed to restore Demo DB
- import "instaces/services/accounts to this..."
Regards
egnaz