How to move the Enterprise Vault (EV) SQL databases

Article:TECH35744

Created: 2004-01-25

Updated: 2013-02-06

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

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

This article describes how to move the Enterprise Vault databases to a different SQL server or a new version of MS SQL Server.

To watch a video on this process see below.

Solution

This process will consist of the following steps.

Step 1 - Determine location of databases (Enterprise Vault server)

Step 2 – Configure permissions and protocols (New SQL server)

Step 3 – Backup, detach and copy the databases (Old SQL Server)

Step 4 – Attach the databases (New SQL Server)

Step 5 – Update the Fingerprint database (New SQL Server)

Step 6 – Update the Monitoring database (New SQL Server)

Step 7 – Update the Directory database in the Registry (Enterprise Vault Server)

Step 8 – Update the Vault Store database (Enterprise Vault Server)

Step 9 – Update the Audit database (Enterprise Vault Server)

Step 1 – Determine location of databases (Enterprise Vault server)

1. Take note of the Directory, Fingerprint and Vault Store databases.

Directory database
a. Right click the Enterprise Vault site and select Properties

b. Click Change Directory SQL Server

c. Take note of the SQL Server listed.

Fingerprint database

a. Right-click the Vault Store Group and click Properties

b. Click the Database tab

c. Take note of the SQL Server listed.

Vault Store database

a. Right-click the Vault Store and click Properties

b. Click the Database tab.

c. Take note of the SQL Server name and Database name.

2. Stop all Enterprise Vault services

Step 2 – Configure permissions and protocols (New SQL server)

1. Confirm the Vault Service account is a member of the local administrators group.

2. Confirm the Vault Service account is assigned the dbcreator role.

a. Open SQL Server Management Studio

b. Expand Security > Logins > right-click the Vault Service account and select Properties.

c. Click Server Roles and confirm dbcreator is checked.

3. Confirm TCP/IP and/or Named Pipes are enabled.

a. Open SQL Server Configuration Manager

b. Expand SQL Server Network Configuration and click Protocols for <instance name>.

c. Confirm Named Pipes and/or TCP/IP is Enabled under the Status.

Step 3 – Backup, detach and copy the databases (Old SQL Server)

1. Backup the Enterprise Vault databases.

2. Open SQL Server Management Studio, right-click the database that should be moved and click Tasks > Detach.

3. Click Drop Connections to force any active connections to the database to be dropped and click OK.

Note: A confirmation message is not generated but the database is no longer displayed.

4. Repeat the steps for any additional databases that will be moved.

5. Browse to the database and log file location and copy the databases and logs to the new SQL server.

Step 4 – Attach the databases (New SQL Server)

1. Attach databases

a. Open SQL Server Management Studio, right-click Databases and click Attach.

b. Click Add, browse to the database file and click OK.

c. Browse to the Log File location and click OK.

d. Repeat the steps for any additional databases.

Step 5 – Update the Fingerprint database (New SQL Server)

(Note: This step is required only if a fingerprint database has been configured. Fingerprint databases only exist on version 8.0 and later.)

a. Use the instructions and prewritten SQL script in the following article: http://www.symantec.com/docs/TECH64655

b. Repeat for each fingerprint database.

Step 6 – Update the Monitoring database (New SQL Server)

1. Open SQL Server Management Studio

2. Run the following query, substituting the New_SQL_Server value with the hostname of the new SQL server:

USE EnterpriseVaultDirectory
UPDATE MonitoringSettings
SET SQLServer = 'New_SQL_Server'

Step 7 – Update the Directory database in the Registry (Enterprise Vault Server)

1. Click Start > Run, type regedit and click OK.

For 32bit systems, HKEY_LOCAL_MACHINE\Software\KVS\Enterprise Vault\Directory\DirectoryService.

For 64bit systems, HKEY_LOCAL_MACHINE\Software\Wow6432Node\KVS\Enterprise Vault\Directory\DirectoryService

2. Double-click the SQLServer Name string value.

3. Enter the name of the new SQL server in the value data field and click OK.

4. Start the Enterprise Vault Directory Service, this will also start the Admin Service.

Step 8 – Update the Vault Store database (Enterprise Vault Server)

1. Open 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 remaining Enterprise Vault services.

Step 9 – Update the Audit database (Enterprise Vault Server)

Note: No Enterprise Vault services need to be stopped for this step.

Summary: The EVAudit System DSN must be updated with the new location of the audit database.

1. For 32bit systems, Open Data Sources (ODBC) from the Administrative Tools panel on the Enterprise Vault Server. For 64bit systems, browse to %systemroot%\syswow64\odbcad32.exe

2. Select the System DSNtab.

3. Select the EVAuditentry.

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.