Database Backup


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 (e.g. Names, Phones, Emails, HKID, Passport, Addresses, etc)  is excluded in that backup set 
Personal Data Protection Backup is good to deliver the database backup to third party  (e.g. HRPro Authorized Solution Providers or HRPro Consultantsthat 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. (This feature only applicable only if the Microsoft SQL Server and Microsoft Internet Information Server are installed at the same Windows Server Operating System)

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

See also: