Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K 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
- 298 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
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to restore the datas only ?
chandrurec
Member Posts: 560
Hi all,
I have got the backup file with me. Is there any option by which i can restore the datas only during backup without the objects.
For this I want to delete the existing datas which is already present in the database and then I should restore only the backup datas during restoration so that I get the database with the datas from the backup.
if any knows how to achieve this , kindly tell me.
Thanks in advance.
Regards,
chandru.
I have got the backup file with me. Is there any option by which i can restore the datas only during backup without the objects.
For this I want to delete the existing datas which is already present in the database and then I should restore only the backup datas during restoration so that I get the database with the datas from the backup.
if any knows how to achieve this , kindly tell me.
Thanks in advance.
Regards,
chandru.
0
Comments
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I am having a datasbe backup file with me.
Scenario :
In the already existing database I have some datas. With this datas I want to append the datas from backup file. For this I am doing restoring the backup.But when I restore the two options "Data Common to all companies" and "Application Objects" is disables and so I cannot uncheck the Application objects in order to restore only the datas from backup.
How to enable the enable the Application Objects and Data Common to all companies .or is there any other way to restore only the datas.
Thanks & regards,
chandru.
You can only rename existing company, restore new company and than you can use Export/Import or some tool to copy data between companies to copy the data. But still, combining two companies together is not easy task! E.g. what you will do with entry nos. in G/L Entries? When there is entry with no. 123 in both, what you will do with it?
If you want to join two companies, I recommend to transfer the open entries as during go live....
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
I tried to create a new company in the same database and then I tried to restore the backup but still I can see the two options (i.e "Data Common to all companies" and "Application objects") in disables mode only. Is there any option available to enable this.
Thanks & regards,
chandru.
These type of data (objects and data common to all comp.) could be restored only into empty database. For objects there is alternative way: you can import them in same way as any .FOB file (FBK file could be used as FOB file).
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
RIS Plus, LLC
Yes it is.
My vote's with Daniel. Can you explain your position on this?
MVP - Dynamics NAV
My BLOG
NAVERTICA a.s.
You can restore a NAV backup into existing objects, and it will be data only. Your claim that it is only possible with SQL Server is false.
As a matter of fact I would even say that it is more difficult to restore data only using SQL Server backup, because the object table is included in there. We haven't even discussed importing an additional company into an existing NAV database.
RIS Plus, LLC
A bold statement from an MVP...
RIS Plus, LLC