Updating the Quarantine Database in GWGuardian v4.4

TID: 20070307
Date: March 7, 2007
Subject: Updating the Quarantine Database in GWGuardian v4.4
Product Coverage: GWGuardian v4.4

Overview:

The GWGuardian v4.4 WebQuarantine application has been enhanced with new features, such as additional columns of information, so if you are using MSDE, MS-SQL, or MS-SQL Express as your Quarantine database, and you have recently upgraded to GWGuardian 4.4, you may notice that there are no new items in your Quarantine and the Delete All link in the Quarantine Reports generates a “Server is too busy” error. In this case, you must manually update your Quarantine database after upgrading to v4.4.

Procedure:

1. Determine the name of the GWGuardian database by browsing to the C:\Program Files\Microsoft SQL Server\MSSQL\Data\ directory. You should see two files named GWGUARDIAN_DATA.mdf and GWGUARDIAN_LOG.ldf, unless you renamed the database. In this instance, the database is called GWGUARDIAN.
2. In the GWGuardian Administration Console, choose System > Services and stop the MODUSADM service. This will allow you to update the Quarantine database without interference. No mail will be lost during this time, it will just be held in the spool temporarily.
3. Choose Start > Run, and type cmd to open a command prompt. Navigate to the C:\Program Files\Messaging Architects\GWGuardian\DBStructures\SQL Server\Quarantine\ directory within the DOS environment.
4. Type the following command at the command prompt, assuming that your database is named GWGUARDIAN:
   
   OSQL -E -d GWGUARDIAN -i mssql_quarantine_upgrade.sql
   
   If you’ve renamed the database to another name as determined in step 1 above, then use that name here for the -d switch.
   
   Note: Depending on the size of your database, it could take minutes or even hours to run this script.
    
5. Once the update is finished, type the following command:
   
   OSQL -E -d GWGUARDIAN -i mssql_quarantine_manual_upgrade.sql
    
6. In the GWGuardian Administration Console, start the MODUSADM service.

Note: After starting the MODUSADM service, you may notice that your CPU usage increases and that the size of the C:\Program Files\Messaging Architects\GWGuardian\spool\Spam\ directory is decreasing. Once all the files have been written to the Quarantine, you should be able to refresh your Quarantine to see all the newly quarantined items. If you generate a new Quarantine Report, the Delete All link will work as well now.