Hotfix for Enterprise Vault (EV) for Microsoft Exchange 8.0 Service Pack 4 (SP4), Long delays when retrieving items from Virtual Vault due to SQL Blockings

Article:TECH129926  |  Created: 2010-01-12  |  Updated: 2010-01-14  |  Article URL http://www.symantec.com/docs/TECH129926
Article Type
Technical Solution


Environment

Issue



Hotfix for Enterprise Vault (EV) for Microsoft Exchange 8.0 Service Pack 4 (SP4), Long delays when retrieving items from Virtual Vault due to SQL Blockings

Solution



To which versions of Symantec Enterprise Vault can this hotfix be applied?
This hotfix can only be applied to the following versions of Enterprise Vault:
Enterprise Vault 8.0 Service Pack 4 (SP4) Build 1991



What issues does this hotfix resolve?
The delays experienced when opening items from Virtual Vault which are the results of SQL blockings with the 'DeleteArchiveFolders' and 'EVDeleteArchiveFolders' Stored Procedures.

The hotfix updates the above SQL Stored Procedures and creates an additional SQL Index in the EnterpriseVaultDirectory Database as well as in the VaultStore Databases


How to install the hotfix?
As best practices, make sure to have a full backup of the system before making any changes.

1. Place the EV Site in Backup Mode

2. Backup all SQL Databases including the EnterpriseVaultDirectory and the VaultStore databases.

3. To facilitate rollback, also backup the individual stored procedures (note that this will not roll back the new indexes):
DeleteArchiveFolders (in the EnterpriseVaultDirectory Database)
EVDeleteArchiveFolders (in the VaultStore Database)

To backup the stored procedure:
- In SQL Server Management Studio, expand the appropriate database
- Expand 'Programmability'
- Right-Click the Stored Procedure to backup (as per the list above) and select ' Script Stored Procedure as' , 'ALTER To', 'File...'
- Save the file with the name of the stored procedure being backed up. i.e. 'DeleteArchiveFolders_backup.sql' and 'EVDeleteArchiveFolders_backup.sql'


4.  Using an account with DBOwner role, run the following script in SQL Management Studio:
'Directory_DeleteArchiveFolders_1995642_IX.sql' against the EnterpriseVaultDirectory database
'Vault_EVDeleteArchiveFolders_1995642_IXs.sql' against all VaultStore databases in the environment


How to uninstall this hotfix?
1. For a clean uninstallation, ALL the databases will have to be restored to a state prior to the installation of the hotfix
2. To just roll back the Stored Procedures, run the backed up .sql files generated in step 3 above against the appropriate databases. Note that this will not removed the new indexes created


Attachments

Hotfix_1995642_352248.zip (6 kBytes)

Supplemental Materials

SourceETrack
Value1995642
DescriptionLong delays and/or failures experienced when retrieving items from Virtual Vault (due to SQL blocking)

Legacy ID



352248


Article URL http://www.symantec.com/docs/TECH129926


Terms of use for this information are found in Legal Notices