How do I use the System Administrator to back up and restore data?
Description
Cause
Resolution
Creating a backup

  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. [BCB:321:Refer to article:ECB] 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 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.

     

 

 

[BCB:156:Chat 300 CRE US:ECB]











Steps to duplicate
Related Solutions

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