Moving Enterprise Vault SQL Databases
A question that comes about frequently relates to what steps need to be performed if one of the Enterprise Vault databases need to be moved to a new location on an existing SQL Server.
The answer is that in most cases this doesn't have anything to do with Enterprise Vault, it's all purely SQL related. However, if you want to do the belt and braces approach, I'd suggest the following:
- Stop the EV Admin Service
- Move the database using SQL Server Management Studio
- Start the EV Admin Service
The reason for the 'full stop' rather than just putting EV in to read-only mode is that whilst in read-only mode retrievals, and queries in general are still needed against the Enterprise Vault databases.