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
Moving the Reporting Databases
Moving the Reporting Databases | Web, Data, and Email Solutions | 30-Nov-2018
 
This article describes two procedures that can be used to move a Forcepoint reporting database hosted on Microsoft SQL Server to a new location (directory, drive, or machine).
The procedures outlined here are intended to minimize risk of data corruption or loss. Consult a database administrator to determine whether to use either of these procedures.
*
(Recommended) Back up the Forcepoint Web Security, Forcepoint DLP, and Forcepoint Email Security databases in their current location, then restore them to the new location. See Back up and restore the reporting databases.
*
*
*
 
Warning 
Before beginning, make sure that the destination SQL Server instance's collation setting matches that of the source SQL Server instance.
3.
Under the General tab, check the Server Collation value.
Those upgrading to a newer software version should upgrade the Forcepoint software first, then migrate the databases.
Regardless of which procedure is used, for web and email protection solutions, once the databases are in their new location:
1.
2.

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