EV SQL Server Move tool

Article:TECH214373  |  Created: 2014-01-24  |  Updated: 2014-08-13  |  Article URL http://www.symantec.com/docs/TECH214373
Article Type
Technical Solution


Issue



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, Symantec 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.)


Environment



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

• 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

 

 


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:

Parameter Alias Description
-SourceSQLServerName -s Specifies the FQDN of the SQL server from which the databases were moved
-DestinationSQLServerName -d Specifies the FQDN of the SQL server to which the databases were moved
-LogDirectory [filepath] -o Specifies a custom path for the log file (default is the PowerShell working directory)

 

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


Attachments

EV SQL Server Move tool
EVSQLServerMove.zip (6 kBytes)



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


Terms of use for this information are found in Legal Notices