How to set up replicate the Production environment in Test environment? - Navision 2018

(0) Share

Report

Posted on by joshlabtech

662

Hi,

I would like to find out how to do this scenario

I have a Production server with around 5-6 companies. I want to replicate this environment to a test environment in the same server which all the companies in it.

So that I can use it to test. and not test it on the Production server.

Pls advise any youtube video or articles to guide.

Thank you so much.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

Hello,

To make a Full Backup of a NAV Database and Restore it into a NEW NAV Database you will be using SQL Server Management Studio. Here are the steps:

1. Open SQL Server Management Studio

2. Navigate to Database for which you want to create backup. Then Right click the Database. Select Tasks/Backup

3. To create a full backup, select Full, in the Backup Type

4. Choose where to save the backup file using ADD button under Destination

5. Under Options select Verify backup when finished, to ensure that all the files in the backup are readable and can be restored

6. Click OK. Backup file will be generated in the specified location

Now to Restore the Database...

1. In SQL Server Management Studio

2. Right click Databases/Restore Database

3. Select Device and click Assist Edit button

4. Click ADD and navigate to destination where backup file is stored

5. Select .bak file and click OK

6. Click OK in Select backup devices window

7. Fill in the name of the new database

8. Navigate to Options and uncheck the check boxed under Tail-log backup

9. Navigate to Files and update the data file and log file as shown below

10. Click OK

11. Database is restored

You now can create in NAV Server Administration the instance to connect to this restored database.

Hope this answers your question.

Thanks,

Steve

Was this reply helpful? Yes No