1. Obtaining backup from the Production Server
   
2. Setting up the Test Server 
   

Obtaining backup from the Production Server 

1. Stop SupportCenter Plus service on the production server.
   

2. Using the command prompt, go to <SupportCenter_Plus_Home>\ bin directory and execute trimmedBackUpData.bat  to start the Trimmed data backup. Trimmed data backup does not include attachments and custom images. It is sufficient to create a test environment. To know more about backup, click here.
   

3.  Once the backup is complete, a backup folder with the format below is placed under trimmedbackup folder in SupportCenter Plus Home directory. 
      backup_ supportcenter_ [build number] _database_month _date _ year _ hour _minutes.
   The  .data backup files are placed under the respective directories. For example, a trimmed backup taken in Version 11.0 of SupportCenter Plus looks like this:
          backup_supportcenter_11000_database_12_08_2020_15_22.dataThe backup folder/file contains information such as the Build number of SupportCenter Plus, and date and time when the backup was performed.

Setting up the Test Server 

Data should be restored ONLY across the same builds of SupportCenter Plus. (i.e.) data backed up in 11000 builds can be restored only in 11000 builds.

1. Help>>About in the application.
   
2. From buildInfo.xml file under <SupportCenter_Plus_Home>\Conf directory.
   

1. Download SupportCenter Plus with the same build number as in the Production Server from this link. For older builds, click here.
   

2. Now start and shut down the Test set up application once.
   

3. Copy the backup taken from the production server to the Test server.
   

4. To restore the backed up data, Go to <SupportCenter_Plus_Home>\bin directory and execute restoreData.bat.
   

5. Choose the backup file while prompted as in the screenshot given below,
   <SupportCenter_Plus_Home>\bin>restoreData.bat

6. Provide the backup file password when prompted. The default password is SCP123!
   

7. Once the data is restored successfully, stop the application from fetching emails.            
   

   
   

   1.  Using command prompt go to <SupportCenter_Plus_Home>\ bin in the command prompt and execute the startDB.bat 65432
      

   2.  Connect to the database:
                  Postgres: Navigate to <SupportCenter_Plus_Home>\ pgsql \ bin and execute the following.   
                               psql -h localhost -U scpadmin -p 65432 -d supportcenter                       
                              Enter password when prompted: The default password is scp@123 
                  MS SQL: Connect using SQL studio.
      

   3. Execute the below queries one by one :
                 update outgoingmailserver set HOSTNAME =’ALPHA’;
                 update outgoingmailserver set ALTERNATEHOSTNAME=’BETA’;
                 update incomingmailserver set HOSTNAME =’XYZ’;
                 update TASK_INPUT set OPERATIONAL_STATUS=’4′;  

8. Start SupportCenter Plus in the test server.