Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Web Security Reporting FAQ : How do I archive Log Database partitions (or bring archived partitions back online)?
How do I archive Log Database partitions (or bring archived partitions back online)?
50377 | Reporting FAQ | Web Security Solutions | Updated 22-Oct-2013
Applies to:
Websense Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.7 and 7.8
Many organizations have older Log Database partitions that are no longer used (or rarely used) for reporting. The organization may want to preserve the data, but don't want it taking up space on the Microsoft SQL Server machine.
It is possible to archive database partitions, removing them from the SQL Server host. If it later becomes necessary to report on data in the archived partition, you can restore and re-enable the partition.
Archiving a Log Database partition
To archive older data, start by using the Microsoft SQL Server backup process, then take the partition offline and move it to a longer-term storage location.
1.
Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2005 or 2008 or 2012 > SQL Server Management Studio) and log on to the SQL Server instance that hosts your Websense Web Security Log Database.
2.
In the Object Explorer, under Databases, locate the partition you want to archive. By default, the name takes the format wslogdb70_n, where "n" is the partition number).
3.
Right-click the partition and expand the Tasks menu, then select Back Up.
4.
In the Back Up Database window, you can either accept the default backup Destination, or click Add to specify a new path for the backup file.
5.
When you are finished, click OK to run the backup.
6.
When a prompt indicates that the backup process is complete, click OK.
7.
Right-click the partition in the Object Explorer again, then select Take Offline.
8.
Close Microsoft SQL Server Management Studio.
9.
Move the partition to your long-term storage location.
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.
1.
Open SQL Server Management Studio (Start > All Programs > Microsoft SQL Server 2005 or 2008 or 2012 > SQL Server Management Studio) and log on to the SQL Server instance that hosts your Websense Web Security 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 TRITON console and navigate to the Web Security 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.
When you are finished reporting on the historical data, you can take the partition offline and remove it from the SQL Server machine again.

Go to the table of contents Go to the previous page Go to the next page View or print as PDF
Web Security Reporting FAQ : How do I archive Log Database partitions (or bring archived partitions back online)?
Copyright 2016 Forcepoint LLC. All rights reserved.