Monday, January 29, 2018

Dynamics NAV - LS Retail - How to restore a copy of the live server to a test server


  • 1) Stop the TEST NAV service

    • 2) Backup live database and restore over test database in SQL Management Studio
    • 3) Run these scripts to disable the scheduled jobs
    • --------------Disable jobs
    • update  [CRONUS$Scheduler Job Header]
    • SET [Next Check Date] = '1753-01-01 00:00:00.000', [Next Check Time] = '1753-01-01 00:00:00.000'
    • 4) Change the web service setup info 
    •  - Departments/LS Retail/Administration/Web Service
    •  - Change the Server Computer Name = 192.168.10.226
    •  - Change the Server Port = 13047
    •  - Change the Server Name = OMNI

    • 5) Change the TS60 location to point to the test
    •  - Departments/LS Retail/Scheduler/Distribution
    •  - Change Db Server Name = SECSQLSRV
    •  - Change Db Path & Name = CROMNI
    •  - Under Web server Fasttab
    •  - Change Web Server Computer Name = 192.168.10.226
    •  - Change Web Server Port = 13047
    •  - Change Web Server Name = OMNI

    • 6) Restart TEST NAV service

    No comments:

    Post a Comment