Restoring databases

You use the Restore tool to restore selected databases to the states that they existed as of a certain time and date.

During restoration, Estimating Management Console checks whether the backup was created using the same version of Sage Estimating that you currently use. If the database was created using an earlier version, Estimating Management Console updates the database as part of the restoration process.

Note: You need to restart Estimating Management Console to refresh the databases, completing the restoration process.

Before you start

Make sure no other users are working with the databases you are going to restore. None of the fields on Restore Databases tab are available until you confirm that you have exclusive access to the databases.

If you are restoring data from a remote location, make sure you have access to the remote server.

To restore a database:

  1. On the ribbon in the Estimating Management Console, click the [Tools] button.
  2. In the navigation pane, click Restore.
  3. After verifying that no users are working with the databases you are going to restore, select the Exclusive access confirmed checkbox on the Restore Databases tab.

    Estimating Management Console displays all your Sage Estimating standard and estimate databases in the table.

  4. In the Select the location of the folder that contains the backed-up databases, type the path to the location of the backup folders.

    Important! If your computer is pointing to a backup location on a remote server, you need to type the path with respect to the remote machine, not your local computer. For example, C:\users\public\sage\estimating\backup would be the C drive of the remote server.

  5. In the grid:

    1. Select the databases you want to restore.

      Tips:

      • You can use the filter Filter icon icon in any column header to filter the databases in the grid to match criteria that you specify for that column.
      • You can use the sort Sort icon icon in a column header to sort the databases in the grid in ascending or descending order by that column.
      • Use the checkbox in the Restore? column header to select or to clear the all the databases in the list.
    2. In the Restore To column, accept or change the name of the database to which to restore the data.

      Note: The program will not overwrite an existing database.

  6. Click [Restore].

    If there was an error restoring a database, the result appears in the table together with a short description of the type of error that caused the restoration to fail.

  7. When prompted, click [Restart Application].

After restoring a database

  • If you restored a standard database that is missing data added since you created the backup, consider merging the recent database with the restored standard database, creating a new database. For more information, see About Merging Databases andRules for merging databases.

  • If you restored an estimate database that is missing data added since you created the backup, consider exporting the current estimates and then importing them into the restored estimate database.