Documentation | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Moving the Reporting Databases : Detach and reattach the Forcepoint DLP databases
Detach and reattach the Forcepoint DLP databases
Moving the Reporting Databases | Web, Data, and Email Solutions | April 2022
 
Applies to:                                         
*
Forcepoint Web Security and Forcepoint URL Filtering, v8.5.x
*
Forcepoint DLP, v8.5.1, v8.6.x, v8.7.x, v8.8.x, v8.9.x
*
Forcepoint Email Security, v8.5.x
*
Forcepoint appliances, v8.5.x
To move the Forcepoint DLP databases by detaching them, manually moving files, and then reattaching them in a new location, use the following procedure.
1: Detach the databases
1.
Log off of the Forcepoint Security Manager.
2.
On the management server, use the Windows Services tool to stop the Websense Data Security Manager service.
3.
Change the service startup type to Disabled.
4.
On the SQL Server machine, open Microsoft SQL Server Management Studio.
5.
Log onto the SQL Server instance that hosts the Data Security database.
6.
Detach the wbsn-data-security and wbsn-data-security-temp-archive databases as follows:
a.
Expand the Databases folder.
b.
Right-click one of the databases, and then select Tasks > Detach.
c.
Repeat this process for the other databases. The order does not matter.
The Forcepoint DLP database has now been detached from its original location.
2: Move the database
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.
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:
a.
Expand the nodes in the left navigation pane until the Databases folder is displayed, then right-click that folder.
b.
Select Attach, then click Add.
c.
Navigate to the location of the mdf and ldf files, then select a partition database mdf file.
d.
Repeat this process for each database.
e.
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).

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Moving the Reporting Databases : Detach and reattach the Forcepoint DLP databases
Copyright 2022 Forcepoint. All rights reserved.