Backup & Restore (from 14000) - Behavior changes

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 M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • 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 ...

                    • How to restore your data in ServiceDesk Plus

                      1. Stop the ManageEngine ServiceDesk Plus service from the Services console(services.msc).   2. Click the Windows icon and select Command Prompt (Admin).   3. Go to Bin directory and run restoreData.bat   4.Browse to the backup file from backup ...

                    • 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 ...

                    • 11.0 Behavior changes wrt to admin operations

                      Module wise behavior changes : https://workdrive.zohoexternal.com/sheet/open/49yu6b27a538df41d4713b7ecdfbe3d0a5198 Settings wise behavior changes : https://workdrive.zohoexternal.com/sheet/open/6ji296663cae2c657417db16845f74c376f0e 11.0 Licensing ...

                    • 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 ...

                      Related Products