2: Move the database

Before you begin

Once the Forcepoint DLP database has been detached from its original location, move it to the new location, reattach it to SQL Server, and modify Forcepoint DLP settings.

Steps

  1. Copy the following files from the /Data folder on the source SQL Server machine to the /Data folder on the target SQL Server machine:
    • wbsn-data-security.mdf
    • wbsn-data-security_log.LDF
    • wbsn-data-security-temp-archive.mdf
    • wbsn-data-security-temp-archive_log.LDF
  2. On the target SQL Server machine, open Microsoft SQL Server Management Studio.
  3. Attach the wbsn-data-security.mdf and wbsn-data-security_log.LDF databases as follows:
    1. Expand the nodes in the left navigation pane until the Databases folder is displayed, then right-click that folder.
    2. Select Attach, then click Add.
    3. Navigate to the location of the mdf and ldf files, then select a partition database mdf file.
    4. Repeat this process for each database.
    5. Click OK when all databases have been selected.
  4. On the management server, run the Forcepoint Security Setup wizard, select Modify, and then modify the settings to use the target SQL Server.

    If the databases are being moved from a local SQL Server Express instance to a remote Standard or Enterprise Edition instance, edit /Websense/EIP Infra/ EIPSettings.xml before running modify. Set the External value to true:

    <External>true</External>
  5. Run the Modify wizard for Forcepoint DLP and modify the settings for Temporary File Location. (Verify that all UNC path are accessible.)
  6. Delete the content of the following folders from the management server:
    • %dss_home%\tomcat\work
    • %dss_home%\tomcat\temp
  7. Using the Windows Services tool, set the Websense Data Security Manager service startup type back to Automatic and start the service.
  8. Log on to the Data Security module of the Security Manager and click Deploy. Verify that data from the database is visible (for example, in incident reports).