RecordPoint Database Migration to Existing SharePoint Farm

Owned by Laura Boustany
Last updated: May 28, 2020
4 min read

This topic covers how to backup an existing RecordPoint environment and restore it onto a different existing farm already using RecordPoint. To restore it onto a brand new farm instead, click RecordPoint Database Migration to New SharePoint Farm.

For the remainder of this article, "Source Farm" will refer to the RecordPoint environment that is being backed up, and "Target Farm" will refer to the environment being restored onto. Make a note of the Source Farm's RecordPoint URL as this will be needed later.

Steps for the Source Farm:

Identify and Backup Content Databases

  1. Navigate to Central Admin

  2. Application Management

  3. Manage content databases. Identify which content databases need to be backed up for both RecordPoint and your active site(s):

    1. Active Site Databases - select the web application(s) for the active site(s). Each listed database will need to be backed up.

    2. RecordPoint Databases - select the web application for RecordPoint. Each listed database will need to be backed up (there will be a minimum of three databases here).

The only supported method to backup and restore databases of a RecordPoint environment is through SQL Server Management Studio. Follow the steps under "Use SQL Server Tools..." from this article and backup your databases. These backup files will then need to be copied somewhere accessible by the SQL Server Management Studio of the Target Farm.

Export the Term Set

Use the script found here to export the RecordPoint Term Set in your Managed Metadata Service. Copy this file into the Target Farm.

Export RecordPoint Rules

  1. Navigate to your RecordPoint Site

  2. Management

  3. Rule Settings.

  4. Click Export Rules.

  5. Copy this file into the Target Farm.

Steps for Target Farm:

Restore the databases on the new environment

Follow the steps under "Use SQL Server Tools..." from this article and restore each of your databases from step 1. When specifying the Source, select "Device" and choose a backup file. Give the Destination Database a new name only if a database with the backup source's name already exists - otherwise, keep the default value.

Remove and Attach Databases

  1. Navigate to Central Admin

  2. Application Management

  3. Manage content databases. 

    1. Active Site Databases - select the web application(s) for the active site(s) and remove each existing database. Add the Active Site databases that were restored in step 4.

    2. RecordPoint Databases - select the web application for RecordPoint and remove each existing database. Add the RecordPoint databases that were restored in step 4.

  4. Perform an IIS reset and restart the SharePoint Timer Job Service on all servers.

Add Alternate Access Mapping (AAM)

  1. Navigate to Application Management

  2. Configure alternate access mappings.

  3. Click Add Internal URLs, select the RecordPoint web application, and add the Source Farm's RecordPoint URL to the default zone.

Import the Term Set

Navigate to the Managed Metadata Service and import the Term Set CSV file generated in step 2 into the RecordPoint group. 

Re-add Timer Jobs to Active Sites

  1. Navigate to Central Admin

  2. Application Management

  3. RecordPoint Deployment and Configuration

  4. Configuration then click Next. The timer jobs will be re-added by disabling then re-enabling certain features here.

  5. Select the Active web application and site, check "Show Administrative Components" and click OK.

  6. Uncheck the following features then click Update:

    1. RecordPoint Active Daily Tasks Infrastructure

    2. RecordPoint Active System Monitor

    3. RecordPoint Queueing Infrastructure Active Site

  7. After the results show that the above features have been disabled, recheck these features and click Update again. When they have been enabled, repeat this process for each Active site collection as needed. Click Finish when done.

Steps for the Target Farm's Active Site(s):

Using a farm account, navigate to your Active site(s) and perform the following:

Update URL for RecordPoint

  1. Navigate to Site Settings

  2. General Settings under the RecordPoint heading. Change the URLs to the Target Farm's RecordPoint URL and click Update. 

Repeat step 10 for each Active Site as needed.

Steps for the Target Farm's RecordPoint Site:

Using a farm account, navigate to your RecordPoint site and perform the following:

Update RecordPoint URLs

  1. Navigate to Management > General Settings. Change the Site URL field to the Target Farm's RecordPoint URL and click Update.

    1. Append "/Lists/RecordPointConfig/" to your RecordPoint URL. Confirm that the URL values in the following fields match the Target Farm's RecordPoint URL:

    2. RecordPointSiteUrl

    3. ISO15489RecordStorageSettings

    4. ISO15489BinaryStorageSettings

    5. ISO15489FileStorageSettings

    6. ISO15489BoxStorageSettings

    7. StorageSiteSettings (there will be a minimum of two URL values here)

  2. These fields should already contain the proper URL once the URL in General Settings has been updated. If not, then update them now. In addition, you will need to update the following field as this will not change automatically:

    1. TransferConversionUrl

Update Term Store Selections

  1. Navigate to Management

  2. Pack Settings.

    1. Under "Select the Transfer Standard...", there may be fields that reflect the VERS standard despite it not being selected. If this is the case, in the dropdown you can click "VERS" and then click "Select .." again to make the fields disappear. 

    2. Select the proper Term Store/Group/Set and click Update.

Import RecordPoint Rules

  1. Navigate to Management

  2. Rule Settings

  3. browse for the rules file and click Import Rules.

  4. Keep "Delete all rules prior to import" checked. This is needed to repopulate the outcomes with the proper classifications.

If there are any patterns that reference a root URL of any Source Farm Active Site, then these will need to be updated accordingly.

The account being used for this step must be an administrator with full control over the search and managed metadata services. 

  1. Navigate to Management

  2. Search Settings.

    1. Choose the proper Search Application and click Update.

    2. Click Initialise. If you had to update the Search Application above, then you may need to refresh the page in order to click this. Note that this will run two full crawls 

Once all steps have been completed successfully, RecordPoint will be ready for use with the updated content.