Uninstalling the SQL scripts added by the ‘Veritas.EnterpriseVault.Reports.mp’ management pack
Article ID: 100038535
Updated On:
Description
Description
When Enterprise Vault Reports Management Pack (Veritas.EnterpriseVault.Reports.mp) is imported, it installs custom SQL scripts for stored procedures and functions.
When this management pack is deleted, these SQL scripts are not uninstalled. This is an issue with System Center Operations Manager (SCOM) itself.
To uninstall the SQL scripts after you have removed the management pack, follow these steps:
1) Stop the Operations Manager services (System Center Data Access Service, System Center Management Service, and System Center Management Configuration Service) on all management servers in the management group.
2) Use SQL Server Management Studio to create a full backup of OperationsManager and OperationsManagerDW databases. Use an account that has rights to take a backup of OperationsManager and OperationsManagerDW databases.
3) Run the attached SQL script against OperationsManagerDW database using SQL Server Management Studio. Use the database owner account of the OperationsManagerDW database to run this script.
4) Start the Operations Manager services (System Center Management, System Center Data Access, and System Center Management Configuration) on all the management servers in the management group.
IMPORTANT: Do not edit this content in Information Manager
Internal Notes
The content of this document is referenced in the Enterprise Vault Documentation. Do not make changes to this article. If you would like changes to be made to this content, use the Information Manager feedback feature. Alternatively, you can send e-mail to the owner or the Enterprise Vault Knowledge Management team DL-CS-KM.
Issue/Introduction
Uninstalling the SQL scripts added by the ‘Veritas.EnterpriseVault.Reports.mp’ management pack
Was this article helpful?
Yes
No
Powered by
