How do I use the System Administrator to back up and restore data?

1. Have all users close all Sage applications.
2. Close all third-party applications that may access Sage 300 CRE data.
3. Log in to the Sage 300 CRE file server as an administrator.
4. From the Windows Start menu, launch System Administrator.
   • Default local path on the server: C:\Program Files (x86)\Timberline Office\Shared\SystemAdministrator.exe
5. Log in as a Sage Application Administrator.
6. If you use Sage SQL Replicator, click Connect, otherwise, click Cancel.
7. Select Backup from the left navigation menu.
8. Select the Backup checkbox in front of each company in the grid that you want to include in the backup file.
9. On each line item, select whether to backup All or Data only files.
    NOTE: Data only backups do not back up any file types in the data folder such as xls, pdf, prn, doc, txt, csv, or other non-pervasive related files. Refer to article: System Administrator Backup tool excludes extended data files when the Data Only option is selected.
10. If you want to include other folders outside of the company folder for backup, select Add Folder or Add File and browse to the location of that folder or file.
    Note: The backup utility will not back up empty folders.
11. Select a backup location in the Select the folder to store the backed-up data field.
12. Check the option Automatically back up every day at and select a time if you want to run this daily.
13. Click Save Configuration to save the backup settings for later use.
14. Click Back up Now.

    The backup creates a zip file with the following contents:

• Pervasive data folders for the company(s) you selected to backup
• The SQL database (if you are replicating data)
• Sage\Timberline Office\9.5 folder (without the Wininst folder)
• Any additional folders or files you selected to backup
• Log files with backup information

Restoring a backup

1. Log in to the Sage 300 CRE file server as an administrator.
2. From the Windows Start menu, launch System Administrator.
   • Local path on the server: C:\Program Files (x86)\Timberline Office\Shared\SystemAdministrator.exe
3. Log in as a Sage Application Administrator.
4. If you use Sage SQL Replicator, click Connect, otherwise, click Cancel.
5. From the left navigation menu, select Restore.
6. Click Browse to navigate to the location of your backup. The backup file name will be formatted as backup _ .zip .
7. Confirm the backup contains the data folder(s) you want to restore, then click Restore.
8. Click the I accept the risks associated with restoring my data check box.
9. Click Next.
10. Select the scenario that matches the reason you are restoring your data and continue the steps.

•   Scenario 1 - Restoring a data folder to replace the current live data

  • Restoring only the Pervasive folder to the current live location
  • Restoring both the Pervasive and SQL folders to the current live location
  • Restoring the complete system files to the current live location

   

  1. Select the data folder(s) you want to restore by selecting the Restore Folder checkbox in front of each folder.
  2. Verify the Restore path displayed is the correct path for the live data folder(s). If it is not, use the Browse button to navigate to the new location.
  3. If you are replicating your data into SQL, select Restore SQL to restore your SQL data.
     Caution: You will lose any attachments saved using Mobile Projects between now and the time of the backup you are restoring. Restoring only the Pervasive data will remove any records created between now and the backup date. Those attachments will disassociate from the original record created in the interim.
     Tip: If you check the Restore folder checkbox, the SQL checkbox will automatically become checked. If you decide to uncheck the Restore folder box for a specific data folder, you will need to uncheck the Restore SQL box manually.
  4. If you need to fully restore the 9.5 folder (global security, reports, formulas, report menus, etc.), check the box to Restore Global folders.
  5. Click Next and verify that Restore is performing the expected actions for the folder(s) you chose.
  6. Select Next and acknowledge the warning message regarding data overwrite.
      NOTE: If you have selected to restore to the same location, it will rename the pervasive folder in that location and copy the restored folder into its place. The renamed folder will include the original folder name appended with the date and time of the restore operation. The same rename operation and naming convention will be performed on the SQL database(s).
  7. The Restore will stop replication on all data folders, then proceed to rename the folder(s) in the current location and replace the folder(s) with the backup.
  8. After the operation is complete, select Replication from the menu and ensure it replicates all databases. The Replicating field should be set to Yes.
  9. After the restore is complete, you should open each restored folder in Sage 300 CRE and verify your data.

   

• Scenario 2 - Restoring the data folder to a different location for purposes of testing or archiving
  1. From the Sage Desktop Options menu, select New Company and create a new company for the restored data.
  2. Select the data folder(s) you want to restore by selecting the Restore Folder checkbox in front of each folder.
  3. Use the Browse button to navigate to the new location created in step 1 above.
  4. Clear the checkbox Restore SQL.
     Important: Leaving the “Restore SQL” checkbox checked will cause the SQL database in the current location to be associated with the Pervasive folder in the new location. You should ensure that this checkbox is unchecked unless you want to have the new Pervasive folder location become the ‘live’ data location.
  5. If you need to fully restore the 9.5 folder (global security, reports, formulas, report menus, etc.), check the box to Restore Global folders.
     Note: This will affect all company folders, including your live data. This is not required for reporting or testing purposes.
  6. Click Next and verify that the Restore is performing the expected actions for the folder(s) you have chosen. Verify the new location is correct and whether you expect to restore the SQL data.
  7. Select Next and acknowledge the warning message regarding data overwrite.
  8. The Restore will stop replication on all data folders, then proceed to copy the data folder(s) you selected to the new location.  NOTE: Suppose you have selected to restore the SQL data as well. In that case, it renames the original folder in the SQL database, creates a database with the same name and associates it with the new location for the Pervasive data.
  9. After the operation is complete, select Replication from the menu and ensure it replicates all databases. The Replicating field should be set to Yes.
  10. After the restore is complete, you should open each restored folder in Sage 300 CRE and verify your data.
  11. If you are restoring to a new location to create a copy of your company data for testing or archiving do the following to ensure correct naming for these copied folders:
      1. Open Sage 300 CRE and use click Specify Folders to browse to the path of the new company folder. Select and open the new folder
      2. From the Desktop Common Tasks menu, select File, Company Settings, and General. Rename the new folder in the Company name field and the Data folder Description field if you haven’t already. Select Okay and close. This ensures that this data folder has a unique name and is distinguished as a unique company. It will also ensure that Sage Replicator uses a unique name if you choose to replicate this new folder.
      3. If you do not want the folder to display in Open Company after you have performed the prior steps, you can remove the company from the list by selecting Remove from List on the Open Company window.
  12. If you determine that you would like to replicate this new folder in SQL:
      1. Open the System Administrator window.
      2. Select the newly renamed company.
      3. Follow the process to begin replication.

   

 

Chat with support

Using the System Administrator to back up and restore your data (video)