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.6.x - v7.8.x
Applies to:                                         
*
Web Filter, Web Security, Web Security Gateway, and Web Security Gateway Anywhere, v7.6.x - v7.8.x
It is important that you back up your current Websense reporting databases, stop Log Server, and do one of the following before upgrading to ensure the integrity of your reporting data:
*
Microsoft SQL Server Standard or Enterprise: Stop any active SQL Server Agent jobs. After upgrade, reactivate the jobs to resume normal database operations.
*
SQL Server Express: Restart the MSSQLSERVER service to make sure no Browser Service jobs are running.
 
* 
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.
Step 1: Back up the databases and stop Log Server
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.
Step 2: Make sure no database jobs are running
If you have Microsoft SQL Server Express, use the Windows Services tool to restart the MSSQLSERVER service.
If you have a full version of Microsoft SQL Server:
1.
Log in to the Microsoft SQL Server Management Studio and expand SQL Server Agent > Jobs (in Object Explorer).
2.
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_AMT_ETL_wslogdb70
*
Websense_IBT_DRIVER_wslogdb70
*
Websense_Trend_DRIVER_wslogdb70
*
Websense_Maintenance_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.
Step 3: Upgrade and re-enable the jobs
1.
Perform the Websense upgrade.
2.
After upgrade, if you have a full version of SQL Server, 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.