Enterprise Vault procedure for moving SQL
The following steps are required to move the Enterprise Vault databases to the new SQL server.
1. Install SQL on the new server.
2. Stop all Enterprise Vault services on all Enterprise Vault servers (Stop Enterprise Vault Admin Service).
3. Backup the Enterprise Vault Databases.
4. Verify the backups.
5. Restore the databases to the new SQL server.
6. Verify that the Vault service account has permissions to modify all Enterprise Vault databases on the server.
Instructions for moving the Directory database:
1. From within the Enterprise Vault Administration Console, right-click on the Enterprise Vault level and select Properties.
2. This displays the Enterprise Vault properties page. Click the Change Directory SQL Server button.
3. The Change Directory SQL Server dialog is displayed. Enter the name of the new SQL Server and click OK.
4. A progress dialog is displayed to indicate the change is being made.
5. A success dialog is displayed when the change has been completed.
6. Restart the Enterprise Vault Directory Service.
Instructions for moving the VaultStore databases
1. Stop all Storage Service that manages the vault stores
2. From within the Enterprise Vault Administration Console, right-click on the name of the vault store and select Properties.
3. The properties for the vault store are displayed, select the Database tab.
4. Next to SQL Server, enter the name of the new SQL Server and click OK.
5. Start the Storage Service.