Backing up and restoring data
As with all applications containing important data, the ability to back up your data easily and regularly is vital.
How you back up data depends on how your system is configured:
- If you have an HR-only installation (no Payroll), you can use the Sage HRMS back up and restore utilities. Time Off System > Processes > Backup Data and System > Processes > Restore Data.
- If you have Payroll installed, you must use the back up and restore functions provided with Microsoft SQL Server. The name and location of the database is set up on SQL Server by the administrator and will be the default when you use these processes.
Several processes in Sage HRMS remind you to back up your data before you actually perform the process. If you back up your data before you change it, you can always restore the original data if needed after running the process.
For example, you create a backup of the Sage HRMS database in SQL Server. After creating the backup, you run the mass update process in Sage HRMS to increase the salary of all employees by 10%. Later, it is determined that the pay increase should only be 8%. You use the restore function in SQL Server to restore the Sage HRMS database backup, which contains the data in it's original state, then rerun the mass update process to apply the 8% increase.
For additional information about backing up and restoring your payroll database, refer your Microsoft SQL Server documentation.