Database Export

Overview

The Database Export is a support tool that exports the entire Cascade CMS database to a file, so that Hannon Hill can replicate a client database locally without the client having to go through the trouble of performing a database backup or stopping the server.

The Database Export tool should not be used to back up the Cascade CMS database as a part of routine server maintenance. Standard database backup procedures should be followed.

Note - It is strongly recommended that exports be performed during periods of low activity as exporting can take a considerable amount of time and overall system performance may be impacted.
Note - This functionality is intended for use by Hannon Hill Support staff as part of troubleshooting for specific issues/problems. It is not intended to be used for any other purpose.

Exporting the Database

To perform a database export:

  1. Click the system menu button (  ) > Administration > Export Database.
  2. Configure the following options:
    1. Include contents of File assets - Enable this option only if you've been instructed to do so by Hannon Hill Support, as this can add significant time to the export process.
    2. Keep temporary export file - Enable this option if you'd like to be able to keep the export on the server filesystem to be retrieved manually later.
  3. Click Export.
  4. Wait until the message "Please wait. Your export is being created. This can take a long time." is replaced with the message "Export has completed successfully!"
  5. Click the download link to download the database export.

Enabling Snapshot Isolation on SQL Server

SQL Server needs to have snapshot isolation enabled in order to export the database. To enable snapshot isolation, have the DBA execute the following queries and attempt the export again. 

                ALTER DATABASE [databaseName] SET ALLOW_SNAPSHOT_ISOLATION ON 
ALTER DATABASE [databaseName] SET READ_COMMITTED_SNAPSHOT ON