User Control > Tools > Built-in System Backup – GGP Systems Help Center

📝 Overview

The User Table includes a system backup facility designed to safeguard important system files. Corporate Administrators have access to the Backup Database and Restore Database options from the Tools menu. These functions enable backing up and restoring system files to previous states, ensuring data integrity and recovery options.

💾 Files Included in the Backup

The following system files are backed up and restored using this feature:

File Name	Extension
GGPUSERS	.SRW or .FR3
MOVRLIST	.SRW or .FR3
GGP_AUTH_ADMIN_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_AUTH_DEPARTMENTS_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_AUTH_LICENCE_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_AUTH_POLICY_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_AUTH_USERS_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_LAYER_SUPP_METADATA_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_LOOKUP_QUERIES_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_PERSISTED_PRINTOUTS_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_QRY_CATEGORIES_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_QUERIES_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_SERVICE_SUPP_METADATA_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_THM_QUERIES_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_USER_QUERIES_[TIMESTAMP]	.INI, .DMP, .FMT
GGP_USER_THM_QUERIES_[TIMESTAMP]	.INI, .DMP, .FMT

📁 Backup Location

Backup files are stored in the folder:

...\LOCK\SystemBackup\

Each system backup will be saved with a unique timestamp folder.

⚙️ Automatic Backup Trigger

Whenever any user (not just Corporate Administrators) clicks the Users button in GMAIN32, the system checks for the backup folder. If it does not exist, the folder is created and the above files are automatically copied as a one-time backup.

💡 Recommendations for Use

It is recommended that administrators perform a manual backup when making significant changes to any of the above files.
Run a backup after a successful Pack/ReIndex operation when all User Table records display correctly.
This ensures a fallback position is available with accurate, up-to-date data.

🗃️ Database Support Details

Backup and restore operations include the SQLite system file GGP_SYS.DB3 if configured as the 'SDW' connection string.
For Oracle, SQL Server, and PostgreSQL connections, use the respective DBMS internal backup and restore tools, as this built-in feature does not cover those database types.