Backup Process

Backup Process

Beginning with build 14000, SupportCenter Plus supports native backup and restore for databases. The backup files of builds 14000 or later do not support cross-compatibility between PostgreSQL(bundled with SupportCenter Plus) and Microsoft SQL databases. For migration between PostgreSQL and Microsoft SQL databases, follow the instructions in this guide.

Customers using Microsoft SQL Server must ensure the availability of disk space and also should handle proper cleaning up of older backup files.

The SQL dump or database dump backup method will be used for PostgreSQL offline backup, PostgreSQL external backup, and backups during upgrades.

The binary backup method will be used for Microsoft SQL backups and in scheduled backups of applications when using the bundled PostgreSQL.
 

The native backup methods do not support the partial restoration of the database nor support restoration, ignoring table errors.

From build 14000, the backup of the application that uses MS SQL database, you need  db_backupoperator, dbcreator, or sysadmin roles/permission.

From build 14000, the backup of the application that uses MS SQL database does not require any additional files.

For build 14000 or later, the native backup generates only a single EZIP file. In older builds, the backup is split into multiple files each capped at 1GB.

Compatibility of Backup Files for build 14000 or later


Database

Backup Type

Restore

Remarks

PostgresSQL 64 bit (windows)

Schedule

Postgres 64 (windows)

Same OS it will work

PostgresSQL 64 bit

schedule

PostgresSQL 32 bit

Not supported

PostgresSQL 32

schedule

PostgresSQL 32 bit

 

PostgresSQL 32

schedule

PostgresSQL 64 bit

not supported

Microsoft SQL Server

schedule/offline

Microsoft SQL Server (different SQL server)

not supported. If backup taken on sdp-win8-64 . restore will work for same server configuration

Microsoft SQL Server

schedule/offline

Microsoft SQL Server (same sql server)

It will work

PostgresSQL (postgres (any bit/any os)

offline

PostgresSQL (any bit/any OS)

will work


Backup Process in Windows

  1. Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.

  2. Click Start > Programs > ManageEngine SupportCenter Plus > Backup Data. [OR]

    From command prompt, go to <SupportCenter Plus>\bin directory and execute the backUpData.bat as shown below,

C:\ManageEngine\SupportCenter Plus\bin\backUpData.bat

  1. A backup of the data in the database and the file attachments that have been added in the application is created in <SupportCenter Plus>\backup directory. The backup file has to be a .data file.

A backup of the data in the database and the file attachments that have been added in the application is created in <SupportCenter Plus>\backup directory. The backup file has to be a .EZIP file (for build 14000 or later) or .DATA file (for builds before 14000). The file name for the backup file will be in the pattern below.

          For build 14000 or later:

          backup_databasename_[build number]_fullbackup_month_date_year_hr_min.ezip

          Example: backup_mssql_14000_fullbackup_01_18_2011_15_28.ezip

          For builds before 14000:

          backup_databasename_[build number]_fullbackup_month_date_year_hr_min.data

          Example: backup_mssql_11000_fullbackup_01_18_2011_15_28.data

SupportCenter Plus is designed in such a way that the file attachments are not stored in the database. The attachments are stored in the file attachments folder of the installation directory (C:\ManageEngine\SupportCenter Plus). If you are upgrading the server, then you can save time by performing a backup without file attachments i.e., backup of the database alone.


Always schedule the backup to run only during your maintenance slots or planned downtime because the backup process can run for a long time, which could potentially lead to unplanned downtime costs.
 

Backup Process in Windows without file attachments or Trimmed backup

A trimmed backup takes the database backup without file attachments, inline images, custom, billreports, and archive folders.

  1. From command prompt, go to <SupportCenter Plus>\bin directory and execute trimmedBackupData.bat command to start the database back up.

C:\ManageEngine\SupportCenter Plus\bin\trimmedBackupData.bat

  1. Once the backup is complete, a backup file with .data extension is placed in the Trimmed Backup folder under the SupportCenter Plus Home directory.

  2. The backup file contains information such as the Build number of SupportCenter Plus, and the date and time when the backup was performed. Here is the format of the backup file.

  3. For build 14000 or later:
    backup_ databasename_ [build number] _database_month _date _ year _ hour _minutes.ezip
    Example:  backup_mssql_14000_database_01_18_2011_15_28.ezip

  4. For builds before 14000:
    backup_ databasename_ [build number] _database_month _date _ year _ hour _minutes.data
    Example:  backup_mssql_11000_database_01_18_2011_15_28.data

Back up Process in Linux

Follow the steps given below to take a backup of the ManageEngine SupportCenter Plus data:

  1. Shut down ManageEngine SupportCenter Plus service before you perform a backup of your data.

  2. Go to <SupportCenter Plus>/bin directory from the command prompt.

  3. Execute the backUpData.sh file as given below:

$ sh backUpData.sh

The backup file is created in the <SupportCenter Plus>/backup directory. The backup file has to be a .EZIP file (for build 14000 or later) or .DATA file (for builds before 14000). The file name for the backup file will be of the pattern below.

For build 14000 or later:

backup_databasename_[build number]_fullbackup_month_date_year_hr_min.ezip
Example: backup_mssql_ 14000_fullbackup_01_18_2011_15_28.ezip

For builds before  14000:

backup_databasename_[build number]_fullbackup_month_date_year_hr_min.data

Example: backup_mssql_11000_fullbackup_01_18_2011_15_28.data


Back up Process in Linux without file attachments or Trimmed Backup

A trimmed backup takes the database backup without file attachments, inline images, custom, billreports, and archive folders.

  1. From the command prompt, go to <SupportCenter Plus>\bin directory and execute sh trimmedBackupData.bat command to start the database back up.

sh trimmedBackupData.bat

  1. Once the backup is complete, a backup file with .data extension is placed in the Trimmed Backup folder under the SupportCenter Plus Home directory.

  2. The backup file contains information such as the Build number of SupportCenter Plus, and the date and time when the backup was performed. Here is the format of the backup file.

  3. For build 14000 or later:

  4. backup_ databasename_ [build number] _database_month _date _ year _ hour _minutes.ezip
    Example:  backup_mssql_14000_database_01_18_2011_15_28.ezip

  5. For builds before 14000:

  6. backup_ databasename_ [build number] _database_month _date _ year _ hour _minutes.data
    Example:  backup_mssql_11000_database_01_18_2011_15_28.data

Password protection of backup files

After upgrading the application, you will be required to use a password to access the backup files. The SDAdmin configures the password while scheduling the backup. The password can be viewed and reset under Admin > General > Backup Scheduling. This password applies to all files backed up manually as well by schedule.

The password is necessary to restore the application by using the backup files.

When you configure the password afresh or reset it, a notification email is sent to you and to all users configured to be notified each time a backup fails.


    • Related Articles

    • Restore Process

      From build 10600, when restoring the application that uses Microsoft SQL database, you need to have dbcreator or sysadmin roles/permission. Restore Process in Windows Shut down ManageEngine SupportCenter Plus service before you restore the data. From ...
    • Backup Scheduling

      SupportCenter Plus allows you to schedule a periodic backup of the application. This is an application-wide configuration.   To schedule a backup:  1. Go to Admin>>General Settings>>Backup Scheduling (if only one portal is configured) or go to Global ...
    • Backup and Restore

      In Windows  Backup with Attachments  1. Click Start >>Programs >> ManageEngine SupportCenter Plus -> Backup Data.                                                     [OR] Backup from <product_home>\bin directory in the command prompt. Execute the ...
    • Database Migration

      Migration between Postgres and Microsoft SQL SupportCenter Plus comes bundled with Postgres. From build 14000, the database files generated from the scheduled backup are no longer cross-compatible. However, you can migrate between Postgres and ...
    • Performance Tuning Guide

       This guide provides a set of SQL queries and tips that improve the performance of ManageEngine SupportCenter Plus.  Restart the application after executing the queries. The list of performance tips discussed in this guide are: Java Tuning Enabling ...