Create Archive Utility

Create Archive Utility

HelpID: 589922023

To run this utility, you must be logged in as SA.

The Archive Utility will create an archive company by creating an empty database, making a backup of the live database, then restoring the backup of live into the archive database. The final step removes all data in the archive database from tables that will be populated by the archive.

It also removes SQL table triggers from archive tables. SQL Triggers can interfere with the archiving process. This approach to creating an archive database can be faster than creating a new, empty company using GP Utilities.

Database Name: this will default to the current company. You must be logged-in to the live company for which you want to create an archive.

Company Name: name of the current company.

Save Backup To: this will default to the Backup path specified on the SQL server. If it is blank, enter the path to a folder where the backup can be stored. Make sure the backup location has enough free space to store the backup file.

Archive Database Name: provide a 5-character database name for the archive company.

Archive Company Name: provide a company name. This must be different than the company name for any other GP company.

Data File Location: this will default to the data file location specified on the SQL server. Only change this if instructed to do so by the database administrator. Changing the database location later is extremely difficult to do.

Have all users out of the live company before proceeding.

Click Create Archive Company.

NOTE: this process may run for many a long time depending on the size of your company database. GP may appear to be “Not Responding”. Do not force GP to close during this process.