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
- 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
Options
Restore Database Backup from SQL Server to Native
chrini1
Member Posts: 4
Hi together,
we use Navison 4 in connection with SQL Server 2005. For testing purposes we would like to have a local version for one employee. We did a backup to a .bkf file, created a new local C/Side Database and tried to import the backup file. The import works fine, but there are problems:
1. If we do not create new a new user on the database, you cannot log in.
2. The new local user does not have a start menu.
3. The item table is table27 on the SQL, but on native 1000027
The user has no local admin rights.
What is the right process to achive our goal?
Thanks,
Christian
we use Navison 4 in connection with SQL Server 2005. For testing purposes we would like to have a local version for one employee. We did a backup to a .bkf file, created a new local C/Side Database and tried to import the backup file. The import works fine, but there are problems:
1. If we do not create new a new user on the database, you cannot log in.
2. The new local user does not have a start menu.
3. The item table is table27 on the SQL, but on native 1000027
The user has no local admin rights.
What is the right process to achive our goal?
Thanks,
Christian
0
Comments
a) create a new DB-file
b) do the restore. If the restore gives an error at a certain point that the DB isn't big enough => make it bigger => restart the restore. Navision will ask if you want to continue the restore => Continue the restore.
c) when the restore is finished (you MUST get a message that the restore is finished!), create immediately a DB-user as super user in the DB. If you exit the DB it is possible you can't get in anymore and in this case you need to redo all.
Your problems
1) point c) fixes this
2) hit alt+F1 or View=>Navigation pane to show it
3) if you have tables in the 1.000.000.000-range, it means the restore process didn't finish completely. => see b) on how to fix it.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
See its very easy.
Open the Navision with SQL Server Connection.(finsql.exe)
Take a Entire Backup of Database.
Now open Local Navision i.e (fin.exe)
First u create New Database with a propersize.
Now Restore that .fbk file.
so Now u can use that Database on Local Navision.
ok
Actually I do this differently in this situation.
a/ Create the DB to the size needed.
b/ Restore the Backup (fbk), BUT only restore objects and data common to all companies.
c/ DO NOT LOG OUT. But create the new User id in the Datbase and assign them as SUPER.
d/ Log out.
e/ Log back in to check that you have full permissions.
f/ Restore the backup file again, this time restoring the company.
The reason I do it this way, is that 99% of the issue is the time it takes to restore. So if you just restore objects, and common data first, then it's matter of a few minutes. Then if you make a mistake or if the computer crashes (in which case the DB is still good, but locked), then you only lose a few minutes.
By the time you start the full restore, you are already SUPER, so its easy to log back in.
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.