Moving the TRITON Reporting Databases

Topic 50530 | Web, Data, and Email Security | Versions 7.7.x, 7.8.x | Updated 06-Nov-2013

If you need to move your Microsoft SQL Server database to a new location (directory, drive, or machine), this article describes procedures you can use to move your Websense reporting databases to minimize risk of data corruption or loss. Consult your database administrator to determine whether either of these procedures is appropriate for your organization.

(Recommended) You can back up your Websense Web Security, Data Security, and Email Security databases in their current location, and restore them to the new location. See Backup and restore the TRITON reporting databases.

You can detach your Websense Web Security, Email Security, and Data Security databases from their current location and reattach them in a new location. See:

Detach and reattach the Web or Email Security Log Database

Detach and reattach the Data Security databases

If you are performing this procedure while upgrading to a newer Websense software version, be sure to upgrade your Websense software first.

For Websense Web and Email Security solutions, regardless of which procedure you choose, once the databases are in their new location, you must:

Recreate the Websense SQL Server Agent jobs.

Update the Log Server connection to the Log Database and configure the Log Database to create new database partitions in the correct (new) location. See Update Log Server and Log Database settings.

The steps provided in this article are specific to Microsoft SQL Server 2008 and 2005, though they include the option of moving to SQL Server 2012.

Warning

Before beginning, make sure that the destination SQL Server instance's collation setting matches that of the source SQL Server instance.

To check, in SQL Server Management Studio:

Right-click the SQL server instance name and select Properties.

Under the General tab, check the Server Collation value.

Only move the SQL Server databases if the collation values match.