How to Restore NAV 2013 backup in diff domain?

chandrurec
Member Posts: 560
Hi all,
I have read thie article in one of the mibuso forum. Where I found that we need to run this
USE <restored_db>;
TRUNCATE TABLE "User Personalization";
TRUNCATE TABLE "User Property";
TRUNCATE TABLE "Access Control";
TRUNCATE TABLE "User";
GO
and then restore the backup.
This query we need to run for the new db where we are going to restore the backup or for the db from where we are taking the backup.
For example , I am taking the backup from "Test1" database and then restoring the backup of "TEST1" db in newly created "Test2" db which is in different windows domain.
So Now I need to run the above query for "Test1" or "Test2".
Thanks in advance.
Regards,
chandru.
I have read thie article in one of the mibuso forum. Where I found that we need to run this
USE <restored_db>;
TRUNCATE TABLE "User Personalization";
TRUNCATE TABLE "User Property";
TRUNCATE TABLE "Access Control";
TRUNCATE TABLE "User";
GO
and then restore the backup.
This query we need to run for the new db where we are going to restore the backup or for the db from where we are taking the backup.
For example , I am taking the backup from "Test1" database and then restoring the backup of "TEST1" db in newly created "Test2" db which is in different windows domain.
So Now I need to run the above query for "Test1" or "Test2".
Thanks in advance.
Regards,
chandru.
0
Comments
-
This is what I use.
DELETE FROM [User];
DELETE FROM [User Personalization] WHERE [User SID] <> '00000000-0000-0000-0000-000000000001' ;
DELETE FROM [Access Control];
DELETE FROM [User Property];
DELETE FROM [Page Data Personalization];________________________________
Gunnar Gestsson
Microsoft Certified IT Professional
Dynamics NAV MVP
http://www.dynamics.is
http://Objects4NAV.com0
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