How to move the application to another server when you have a MSSQL Database ?

How to move the application to another server when you have a MSSQL Database ?

1. Since you have MSSQL database, take a .BAK backup from the existing SQL server and restore the data on to the new SQL server in the SQL Studio. 

Follow the regular steps of restoring Microsoft database.

2. On your new server,   Install   the 64 bit application(64bit.exe). Install only the build that you are currently using. Before that ensure you are using 64-bit server too.   

3. Once installed, Start  the application, login to double check if you have installed the right build from Help->About at the right top. 

Then, stop the application. 

4. Navigate to  Database configuration wizard  and configure the SQL credentials there. Ensure you map the right database name here and save.     

5. Once you get the success message, Start the application. 

6. Login to the application and check your data. 

7. Now copy the below folders from the old instance to the new instance. 

Fileattachments, inlineimages, custom, images   under   \ManageEngine\ServicedeskPlus MSP. 
    
8. License can be applied under Help->License once you login to the application. License file   adventnetLicense.xml   can be obtained from the OLD installation folder under \ManageEngine\ServiceDeskPlus-MSP\lib. 

If you have any issues, kindly contact us through support@servicedeskplusmsp.com.
 

                  New to ADSelfService Plus?

                    • Related Articles

                    • Migration of SCP from one server to another

                      1. Stop the application on the production server. 2. Take a trimmed backup of the application (backup without attachments) if you are using the default PgSQL database. If you are using MSSQL, you can take a SQL backup (.bak). 3. Download and install ...
                    • Move database from one machine to another

                      Following is the procedure to migrate your ServiceDesk Plus – MSP database from one MSSQL to another. Step 1: Stop ManageEngine ServiceDesk Plus – MSP service. Step 2: Take a backup of the existing data and configuration under MSSQL database. From ...
                    • Database migration from MySQL to Postgres/MSSQL in SCP 8.1

                      We no longer support the use of MYSQL as database in SupportCenter Plus. Hence, we request our users to migrate to Postgres (which is in-built) or Microsoft SQL. Please follow the below steps to carry out the database migration: 1. Shutdown the ...
                    • How to change the database from MySQL/PostgreSQL to MSSQL

                      The steps mentioned below are applicable only if you migrate the DB from PgSQL to MSSQL. This means that the application server is going to remain the same. The data alone is going to be transferred to MSSQL DB from the existing PgSQL DB.    For ...
                    • How to migrate ServiceDesk Plus from one server to another

                      Following are the steps to move data from the existing server to a new server, Step 1: Stop ManageEngine ServiceDesk Plus service. Step 2: Kindly Upgrade ServiceDesk Plus if required. Refer to the link below to check if you are in the latest version, ...