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
Moving the TRITON Reporting Databases
Topic 45172 | Web, Data, and Email Solutions | v8.2.x | Updated 18-Apr-2016
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 TRITON 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 TRITON AP-WEB, TRITON AP-DATA, and TRITON AP-EMAIL databases in their current location, and restore them to the new location. See Backup and restore the TRITON reporting databases.
*
You can detach your TRITON AP-WEB, TRITON AP-DATA, and TRITON AP-EMAIL databases from their current location and reattach them in a new location. See:
*
Detach and reattach the Web or Email Log Database
*
Detach and reattach the TRITON AP-DATA databases
If you are performing this procedure while upgrading to a newer software version, be sure to upgrade your TRITON software first.
For web and email protection solutions, regardless of which procedure you choose, once the databases are in their new location, you must:
1.
Recreate the Forcepoint SQL Server Agent jobs.
2.
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, 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:
1.
Right-click the SQL server instance name and select Properties.
2.
Under the General tab, check the Server Collation value.
Only move the SQL Server databases if the collation values match.

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
Copyright 2016 Forcepoint LLC. All rights reserved.