Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Moving the TRITON Reporting Databases : Detach and reattach the TRITON AP-DATA databases
Detach and reattach the TRITON AP-DATA databases
Moving the TRITON reporting databases | TRITON AP-DATA | v8.3.x | 15-Dec-2016
If you want to move the TRITON AP-DATA 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 from TRITON Manager.
2.
On the TRITON management server, use the Windows Services tool to stop the Websense Data Security Manager service (DSSManager).
3.
Change the service startup type to Disabled.
4.
On the SQL Server machine, open Microsoft SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2008 | 2012 | 2016 > 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 TRITON AP-DATA database has now been detached from its original location.
2: Move the database
Once the TRITON AP-DATA database has been detached from its original location, move it to the new location, reattach it to SQL Server, and modify TRITON 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 you reach the Databases folder, and 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 TRITON management server, run the TRITON Setup wizard, select Modify, and then modify the settings to use the target SQL Server.
If you are moving the database from a local SQL Express to a remote Standard or Enterprise Edition, edit /Websense/EIP Infra/EIPSettings.xml before running modify. Set the External value to true:
<External>true</External>
5.
Run the Modify wizard for the Data component 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 (DSSManager) startup type back to "Automatic" and start the service.
8.
Log on to the Data Security manager, and click Deploy. Verify you can see data from the database—for example, the incidents database or resources list.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Moving the TRITON Reporting Databases : Detach and reattach the TRITON AP-DATA databases
Copyright 2016 Forcepoint LLC. All rights reserved.