How to remove Enterprise Vault SQL aliases.

Article:TECH143188  |  Created: 2010-11-01  |  Updated: 2014-03-17  |  Article URL http://www.symantec.com/docs/TECH143188
Article Type
Technical Solution

Product(s)

Issue



Certain Types of backup software do not support the use of SQL aliases.


Environment



Microsoft SQL Server 2005 and 2008, Windows Server 2003 and Windows Server 2008.


Solution



- The Vault Store Databases
 
Note:  Only the Enterprise Vault Admin and Directory services need to be running for this step.
 
Summary: For each Vault Store, you must specify the new location of the associated Vault Store database.
 
Details:
 
1. From within the Vault Administration Console (VAC), right-click the name of the Vault Store and select Properties.
 
2. Select the Database tab.
 
3. Next to SQL Server, enter the name of the new SQL server and click OK.
 
4. Repeat steps 1-3 for any remaining Vault Stores.
 
5. Start the Enterprise Vault Storage Service.
 
6. Start the remaining Enterprise Vault services.

-Vault Store Databases in SQL
1. Stop all the Enterprise Vault services.
 
2. Open SQL Server Management Studio (SQL Server 2005/2008).
 
3. Open the VaultStoreEntry table located within the EnterpriseVaultDirectory database.
 
4. Modify the SQLServer column for each vault store to reflect the new SQL Server name.
 
5. Important: Ensure that all of the System DSN connections listed in the ODBC Data Source Administrator relating to Enterprise Vault reference the correct Enterprise Vault server.
 
6. Start all the Enterprise Vault services and check the properties of each vault store from within the VAC to ensure that the correct SQL server name is listed on the Database tab

-The Fingerprint Databases
 
1. Stop all the Enterprise Vault services.
 
2. Open SQL Server Management Studio (SQL Server 2005/2008).
 
3. Open the FingerPrintCatalogue table located within the EnterpriseVaultDirectory database.
 
4. Modify the SQLServer column for each vault store to reflect the new SQL Server name.
 
5. Start all the Enterprise Vault services and check the properties of each vault store from within the VAC to ensure that the correct SQL server name is listed on the Database tab

- The Monitoring Database
 
Note: Ensure all Enterprise Vault services are stopped.
 
Summary: You must update the EnterpriseVaultDirectory database with the new location of the monitoring database.
 
Details:
 
1. Open SQL Server Management Studio.
 
2. Open the MonitoringSettings table located within the EnterpriseVaultDirectory database.
 
3. Modify the SQLServer column to reflect the new SQL Server name.

- The Audit Database
 
Note: No Enterprise Vault services need to be stopped for this step.
 
Summary: You must update the EVAudit System DSN with the new location of the audit database.
 
Details:
 
1. Open Data Sources (ODBC) from the Administrative Tools panel on the Enterprise Vault Server.
 
2. Select the System DSN tab.
 
3. Select the EVAudit entry.
 
4. Click the Configure button.
 
5. On the first page of the wizard, under Which SQL Server do you want to connect to?, enter the name of the new SQL server.
 
6. Continue through the wizard and click Finish to apply the changes

- The FSA Reporting Database
 
Note: Ensure all Enterprise Vault services are stopped.
 
Summary: You must update the EnterpriseVaultDirectory database with the new location of the FSA Reporting database.
 
Details:
 
1. Open SQL ServerManagement Studio (SQL Server 2005/2008).
 
2. Open the FSAReportingSettings table located within the EnterpriseVaultDirectory database.
 
3. Modify the SQLServer column to reflect the new SQL Server name.
 



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


Terms of use for this information are found in Legal Notices