How to restore database in SunPlus 5.4.1?


  1. Run Command Prompt as Administrator
  2. Run Step 1-8
  3. Stop Services
    1. SunSystems Connect Server
    2. SunSystems Security Service
    3. SunSystems Session Manager
  4. RESTORE DATABASE
SUNPLUSADV
SU_DOMAINDB
GSDB
  1. Start Services
  2. Open SQL Server Management Studio
    1. Open 
SU_DOMAINDB
Tables
DOMN_DSRCE_CONFIG
SRVR_FILES
C:\ProgramData\Infor\SunSystems\SharedFiles\ServerFiles
ROX_PATH
C:\ProgramData\Infor\SunSystems\SharedFiles\ExampleReports 
  1. User Manager
    1. Settings
      1. SunSystems 5
        1. Configure
          1. Server : <masukan nama server>
          2. Database: SU_DOMAINDB 
        2. Operator Activity 
          1. Clear
  2. Setup.hta
    1. SunSystems Domain Utility Menu (baris paling akhir)
      1. Re-link SunSystems Data to SunSystems Domain
        1. Datasource Name : SU_DOMAINDSN
        2. Instance Name : <Server Name>
          1. Business Unit Group Name : ADVGRP
          2. SQL Server Instance Name: <Server Name>
          3. SunSystems Database Name: SUNPLUSADV
            1. Group Name : SUServices
            2. Group Name : SUClient 
  3. Install/Synchronize Patchset (Stop Services When Installing)