Specify Backup Location

Administration | Backups | Backup

Summary

By default, backups are written to the backup folder on the SQL Server machine.

You can specify a different backup location by using the SQLBackupPath variable in HR.ini.

For example:
[COMP0001]
CompanyName=TreeTop Limited
CompanyPath=C:\Program Files\PayGlobal\TreeTop\
SQLBackupPath=\\PayServer\Backup\

If the PayGlobal application is active when you edit the hr.ini file, you must restart PayGlobal to activate the change.

SQLBackupPath

The path can be:

A local hard drive location.
A network shared location - Must be a UNC (Uniform Naming Convention) path.
Important: You must use a UNC path to specify a network shared backup location - you cannot use a mapped drive.

The service account used to run the SQL Server service must have full modify rights to the shared folder.

Check the account used by your server on the Security tab of the Server properties dialog box.

If the backup path does not exist, then an error message appears when you run the backup. SQL Server will not attempt to create the backup path.

Backup Filename

The SQL Server backup uses a prefix of the company number from the hr.ini file. For example, a backup taken at 9:46am on 14 June 2009 for COMP0001 would be PG0001_20090614_094600.bak. The full file name is displayed in the Backup, Restore, and Maintain Backups windows.