Database Backup

Database Backup is under System Manager

HRPro utilized Microsoft SQL Server database backup function to backup 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 third party (e.g. HRPro Authorized Solution Providers or HRPro Consultants) that is necessary to access the data for trouble shooting other than the Personal data in order to compliance 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 backup to a folder that IIS is allowed to access or change the Identity of the Application Pool of your web site 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 respected to IIS.

  • The SQL Server backup file is deleted.

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