3b: Migrate the database to a new SQL Server host

To move the reporting database to SQL Server on another machine:

Steps

  1. Install the SQL Server on the new machine.
    Note:

    During installation, select the collation that the wbsn- data-security database uses. The SQL Server collation must match the incident and reporting database collation exactly.

    To determine a database collation, use the Microsoft SQL Server Management Studio. Right-click the server name and select Properties, then right-click the database name and do the same. The collation is listed in the Maintenance section.

  2. Open SQL Server Management Studio and log on to the SQL Server instance that will host the reporting databases.
  3. To restore the reporting databases from their backup location:
    1. In Object Explorer, right-click Databases and select Restore Database.
    2. Enter the database name in the To database (or Database) field.
    3. Select From device (or Device) then click the browse (...) button.
    4. With File selected (the default), click Add and browse to the backup location.
    5. Select the databases you want to restore from the Select the backup sets to restore list.
    6. Select the Options page of the restore window, then verify that the Restore As column shows the correct location for the destination (restored) partition.
    7. Repeat steps a through f until all databases have been restored.
  4. Recreate the web or email database jobs on the new SQL Server installation.
    1. Open the Query window and point to your catalog database (default name wslogdb70 or esglogdb76).
    2. Run the following stored procedures:

      exec dbo.usp_update_views;
      go
      exec dbo.usp_create_background_jobs;
      go

    If you are migrating a Web or Email Log Database, continue with Update Log Server and Log Database settings.
  5. Direct the Forcepoint DLP management components to the new database server. To do this, run the Forcepoint Security Setup program, and select Modify.
  6. Direct Forcepoint Email Security to the new database server by navigating to the Settings > Reporting > Log Database page and changing the configuration.