Backup & Restore (from 14000) - Behavior changes
Backup:
POSTGRES & MSSQL:
-> When taking a backup using the command backUpData.bat/backUpData.sh the backup will be created in the EZIP format. This is the native model of PGSQL / SQL.
-> When taking a backup using the command backUpDataOld.bat/backUpDataOld.sh the backup will be created in the .DATA format
-> If it is taken directly in the MSSQL server then the backup will be in BAK format.
Restore:
Postgres:
-> You can restore the Postgres EZIP backup directly using the command restoredata.bat/restoredata.sh into any Postgres installation. (Windows - linux)
-> You can also restore the Postgres DATA backup directly using the command restoredata.bat/restoredata.sh into any installation. (Windows - linux)
-> You cannot restore the BAK format MSSQL backup into postgres server
MSSQL:
-> If it is a MSSQL EZIP backup then it can only be restored into the same MSSQL server and cannot be restored into a different MSSQL server.
-> If it is a MSSQL DATA backup(.data format) then it can be restored into different MSSQL.
-> It is a MSSQL BAK backup then it can be restored into any MSSQL server
In Schedule backup (EZIP format), Cross OS or Cross DB wont restore.
ie. We cannot take a backup from PGSQL and cannot restore in MSSQL. (viceversa)
Also we cannot take a backup from Windows - PGSQL installation and cannot restore in Linux PGSQL installation(viceversa) As its native dump methodology , it wont.
Manual EZIP format :
We can take ezip format by executing backupDB.bat - We can take back up from Windows PGSQL and restore in Linux PGSQL. (vice versa). - Its supported
New to ADSelfService Plus?
Related Articles
How do I restore the backup data?
NOTE: For builds > 10.6 While migrating to different database you can use backupdataold.bat / backupdataold.sh. Here backup will be in .data format and this can be restored in across DB platform. While restoring .data file we have to use below ...Remote AE (Asset Scanning) Behavior changes
You can download the compatible version of Remote AE from the installed version of ServiceDeskPlus-MSP. Please go to Admin > Distributed Asset Scan and make use of the below highlighted. If you already have Asset Explorer in older versions, please ...How do I convert the database from PGSQL to MSSQL?
1. Stop ManageEngine ServiceDeskPlus – MSP service. 2. Take a backup of the existing data and configuration under PGSQL database by following the below steps. Open CMD as an administrator and execute command to start the data backup. ...Query to show total requests and changes with its total worklog hours of a technician- MSSQL
Working ON Builds: 14500 MSSQL: Requests: SELECT rctd.first_name "Technician", count(wo.workorderid) "Sum of tickets handled by him", ...Steps to take PGSQL Dump Backup and Restore
PGSQL – DUMP – Backup Procedure : Login to the MSP application server and perform the below steps, 1. Start the application To take Postgres (Psql) Dump : 3. Open a command prompt and navigate into <ServiceDeskPlus-MSP>/pgsql/bin directory. 4. ...