Database Backup

Database Backup is under System Manager

HRPro utilized the Microsoft SQL Server database backup function to backup the HRPro database.

The default Physical backup location is usually something like C:\Program Files\Microsoft SQL Server\MSSQL.1\Backup,

The user-defined backup location is the path related to the SQL server. (i.e. the SQL server's drive/path). E.g. C:\TEMP will backup the database to C:\Temp on the server.

Please note that there are two databases required to backup

  • Application Database - stored the Application related Data (e.g. Employee Master, Payroll Batches, etc)

  • System Database - stored the System related Data (e.g. User Information, Group Information, Access Rights Information, etc)

When the Produce Personal Data Protection Backup check box is checked, two backup sets will be created,

  • the Normal backup (dbxxx_db_201xxx)

  • the Personal Data Protection Backup (dbxxx_pdpdb_201xxx) that the Personal Data is excluded in that backup set. Personal Data included

    • Names

    • Phones

    • Emails

    • HKID

    • Passport

    • Addresses

    • Photo

    • Spouse information

    • Emergency information

    • Password

    • Attachments

Personal Data Protection Backup is good to deliver the database backup to a third party (e.g. HRPro Authorized Solution Providers or HRPro Consultants) that is necessary to access the data for troubleshooting other than the Personal Data to comply with the Code of Practice on Human Resource Management Compliance Guide for Employers and HRM Practitioners and Data Privacy Law.

You can click the Download button to download the database backup file you selected to your local computer. If the backup file is inaccessible, it may due to either

  • The Microsoft Internet Information Server (IIS) has no proper rights to access the backup file in Backup Location. You may need to back up to a folder that IIS is allowed to access or change the Identity of the Application Pool of your website to LocalSystem. Visit Grant Advance Access Rights for Internet Information Server to see how to change the Identity.

  • The Microsoft SQL Server and Microsoft Internet Information Server are not installed in the same Windows Server Operating System. So the physical location is not valid in respect of IIS.

  • The SQL Server backup file is deleted.

  • the option Enable Download in Database Restore (in System Manager Setup, System Manager panel) is turned off.

Visit Scheduled Backup to see how to define a Scheduled Backup Job to backup the database automatically.