Technical Library | Support

Go to the table of contents Go to the previous page Go to the next page
Upgrading Websense Web Security Solutions > Preparing the Web Security Log Database for upgrade
Preparing the Web Security Log Database for upgrade
Deployment and Installation Center | Web Security Solutions | Version 7.0.x - v7.6.x
 
Applies to:                                         
*
Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.0.x - v7.6.x
It is important that you back up your current Websense reporting databases and stop any active SQL Server Agent jobs prior to upgrading. After upgrade, reactivate the jobs to resume normal database operations.
 
* 
Warning 
If database operations are active during upgrade, the Websense Log Database may be left in an inconsistent state, rendering it unusable.
When this occurs, it can be difficult to fix.
Make sure to stop Log Server and the database jobs, as described below, before upgrading the database.
1.
Back up Web Security reporting databases.
Refer to Microsoft documentation for instructions on backing up databases. The Websense Web Security databases are named wslogdb70 (the catalog database) and wslogdb70_1, wslogdb70_2, and so on (partition databases).
2.
On the Log Server machine, use the Windows Services dialog box (Start > Administrative Tools > Services) to stop Websense Log Server.
3.
Log in to the Microsoft SQL Server Management Studio and expand SQL Server Agent > Jobs (in Object Explorer).
4.
To disable all currently active Websense SQL Server Agent jobs, right-click each of the following jobs and select Disable:
*
Websense_ETL_Job_wslogdb70
*
Websense_IBT_DRIVER_wslogdb70
*
Websense_Mantenance_Job_wslogdb70
Disabling the jobs prevents them from executing at the next scheduled time, but does not stop them if a job is in process.
Make sure all jobs have completed any current operation before proceeding with upgrade.
5.
Perform the Websense upgrade.
6.
After upgrade, enable the disabled jobs to resume normal database operations.

Go to the table of contents Go to the previous page Go to the next page
Upgrading Websense Web Security Solutions > Preparing the Web Security Log Database for upgrade
Copyright 2016 Forcepoint LLC. All rights reserved.