Problem
How to move a Fingerprint Database in Enterprise Vault 11.0.1 and earlier releases.
Solution
If the SQL Server location of a vault store group's fingerprint database has changed, the EnterpriseVaultDirectory database must be updated with the new location.
The attached SQL script can be used to update the Directory database with the required information for EV version 11.0.1 and earlier.
Use the following procedure to move the fingerprint database and update the Directory database:
1. Stop all Enterprise Vault services on all servers.
2. Move the fingerprint database to the new SQL Server. Refer to Microsoft documentation for procedures. Remember that the database may be configured as a multi-device database.
3. Ensure that the SQL Server is running.
4. Copy the contents of the attached script into a SQL Query window.
SELECT @vaultStoreGroupName = N'VSG_NAME', -- The name of the Vault Store Group to be moved. This can be found under "Display Name" in the VaultStoreGroup table.
@fingerprintDBName = N'FPCDB_NAME', -- The name of the database that has been moved to a different SQL server
@newSQLServerName = N'NEW_SQL_SERVER_NAME' -- The name of the new SQL Server
6. Execute the SQL script against the Directory database.
7. Restart the Enterprise Vault services.
Attachments
Was this content helpful?
Translated Content
Please note that this document is a translation from English, and may have been machine-translated. It is possible that updates have been made to the original version after this document was translated and published. Veritas does not guarantee the accuracy regarding the completeness of the translation. You may also refer to the English Version of this knowledge base article for up-to-date information.