Skip to main content
Cartegraph Campus

Restore Database

These instructions apply to on-premise deployments only.

Before you begin:

  • Create a full backup of the existing database.
  • Create a copy of the existing Project Home.

For Three-Tier Configurations

  1. Stop the Application Server App Pool in IIS on your Application server.
  2. Restore the SQL database.
  3. Make sure the App Pool user for the Application Server App Pool for the site you are restoring to, has DBO access to the database.
  4. Start the Application Server App Pool in IIS on your application server.
  5. Merge or replace the Project Home files.
  6. If you are refreshing your test database from the production site:
  • Update the Salesforce instance ID with the one from your test database.
  • Disable GIS Integrations.
  • Disable Notifications, if desired.
  • Disable Automations, if desired.
  1. Make sure the Project Home is set correctly in the System Settings.
  2. Run a Publish.

For Two-Tier Configurations

  1. Stop the Web Server App Pool in IIS on your Web server.
  2. Restore the SQL database.
  3. Make sure the App Pool user for the Web Server App Pool for the site you are restoring to, has DBO access to the database.
  4. Start the Web Server App Pool in IIS on your Web server.
  5. Merge or replace the Project Home files.
  6. If you are refreshing your test database from the production site:
  • Update the Salesforce instance ID with the one from your test database.
  • Disable GIS Integrations.
  • Disable Notifications, if desired.
  • Disable Automations, if desired.
  1. Make sure the Project Home is set correctly in the System Settings.
  2. Run a Publish.

 

  • Was this article helpful?