How to Restore NAV 2013 backup in diff domain?

chandrurec

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.

thegunzo

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];