Technology

How to open a restored SQL backup in a different Network (pc)

Premanath Kumarage · Author
1 min read
Hands on a laptop keyboard with a candlestick trading chart overlaid

You may have come across situations where you need to open a MS SQL backup file in a new environment. For example, you may have taken the MS SQL Database Backup from your client location. Now you may need to restore it your local pc and open the database using your NAV 2015 client.

You may have come across situations where you need to open a MS SQL backup file in a new environment. For example, you may have taken the MS SQL Database Backup from your client location. Now you may need to restore it your local pc and open the database using your NAV 2015 client. These are the steps that you need to follow;

  • Restore the database
  • Open the following table using SQL Server Management Studio and delete all existing data. (Obviously, the Windows User Account names available in the tables need not be using anymore)

Access Control

  • User User Metadata User Property
  • Setup the new database by configuring the CustomSettings.xml file and run the RTC Client. In other words now you can open the database without any issues. You may now create whatever the new accounts using your RTC client.

Written by

Premanath Kumarage

Author

All insights →

Start here

Every piece here started as a client problem. Tell us yours.

A working session, not a sales call. Bring the process your current system fights you on, and we will tell you plainly what it would take to fix it.

Newsletter

One email a month. No filler.

Stay ahead with Microsoft Business Applications.
Insights, implementation advice and practical ideas to help your business get more from Microsoft technology.

By subscribing, you acknowledge MicroCloud 360’s Privacy Policy.