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 Data Security databases
Detach and reattach the Data Security databases
Topic 50900 | Data Security | Versions 7.8.x | Updated 06-Nov-2013
If you want to move the Data Security 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 TRITON console.
2.
On the TRITON management server, use the Windows Services tool to stop the Websense TRITON - Data Security service (DSSManager).
3.
Change the service startup type to Disabled.
4.
On the SQL Server machine, open Microsoft SQL Server Management Studio:
*
Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
*
Start > Programs > Microsoft SQL Server 2008 > SQL Server Management Studio
*
Start > Programs > Microsoft SQL Server 2012 > 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 Websense databases, and then select Tasks > Detach.
c.
Repeat this process for the other databases. The order does not matter.
The Data Security database has now been detached from its original location.
2: Move the database
Once the Data Security 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 security 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 TRITON - Data Security service startup type back to "Automatic" and start the service.
8.
Log onto the Data Security manager and 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 Data Security databases
Copyright 2016 Forcepoint LLC. All rights reserved.