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 |
Problem
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
|
|
| Source | ETrack |
| Value | 1995642 |
| Description | Long 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
Thank you.