EV SQL Server Move tool

Problem

When Enterprise Vault databases are moved to a new SQL server, it is necessary to update several pointers to their locations, as described in Step 5 of the How to move the Enterprise Vault (EV) SQL databases KB article. To help speed this process and minimize errors from manual entry, Veritas Technical Support has provided this PowerShell script to perform the updates in Steps 5A-5E of that article in an automated fashion. (Steps 1-4 and 6 still need to be performed by the administrator.)

Solution

The attached PowerShell script detects all EV SQL databases that exist in common between a specified source and destination SQL server. It will then update EV's record for each database to point to the destination SQL server.

 

Run the script from a PowerShell prompt on the EV server as shown:

 

The script takes the following parameters:

ParameterAliasDescription
-SourceSQLServerName-sSpecifies the name of the SQL server or instance from which the databases were moved
-DestinationSQLServerName-dSpecifies the name of the SQL server or instance to which the databases were moved
-LogDirectory-oSpecifies a custom path for the log file (default is the PowerShell working directory)
-IncludeNonstandardDatabaseNames-nSpecifies the names of EV databases that are not in the standard naming convention but which should also be moved by the script. Use commas to separate multiple database names.

 

Note: If the environment contains more than one EV server, then the script should be run on each of them.

 

Applies To

The script supports EV 8.0 and above. It requires PowerShell 2.0 or greater on the EV Server.

 

Use this script if:

  • You have conventionally named EV databases (Vault Store Databases with "EVVS" prefix, Fingerprint databases with "EVVSG" prefix)
  • You want to update all the database locations at the same time
  • Your EV server has PowerShell 2.0 or later installed
 
  • You have EV databases that do not follow the default naming convention
    • Note: As of version 1.2 of this script, EV databases with nonstandard names can be moved if you specify them using the -IncludeNonstandardDatabaseNames parameter
  • You want to update the database locations in stages, some now and some later
  • Your EV server does not have PowerShell 2.0 or later installed

Terms of use for this information are found in Legal Notices.

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

Did this article save you the trouble of contacting technical support?

No
Yes

How can we make this article more helpful?

Email Address (Optional)