Reporting on an archived partition

To run reports on a partition that you have previously archived and taken offline, use the Microsoft SQL Server restore process, then enable the partition.

Steps

  1. Open SQL Server Management Studio and log on to the SQL Server instance that hosts your Log Database.
  2. Right-click the Databases node and select Restore Database.
  3. On the General page, use the From database field to specify the location of the archived partition backup file.
  4. Select the Options page, then verify that the Restore As column shows the correct location for the destination (restored) partition.
  5. Click OK to restore the database.
  6. When a prompt indicates that the restore process is complete, click OK.
  7. Close Microsoft SQL Server Management Studio.
  8. Log on to the Forcepoint Security Manager and navigate to the Web > Settings > Reporting > Log Database page.
  9. Under Available Partitions, select the newly restored partition and click Enable. The partition is now available for use in reports.

Next steps

When you are finished reporting on the historical data, you can take the partition offline and remove it from the SQL Server machine again.