Veritas Enterprise Vault™ PowerShell Cmdlets
Set-EVDatabaseDetail
Set-EVDatabaseDetail updates the SQL server connection information for an Enterprise Vault database to a new SQL server name. You can update to use either a server name, instance name, listener or a virtual network name.
Set-EVDatabaseDetail takes the following mandatory input parameters:
-ServerName: This can be an instance, listener, server or virtual network name and must be a valid accessible server.
-InputObject: This is a DatabaseDetail object of type Symantec.EnterpriseVault.PowerShell.Core.Output.DatabaseDetail.
Set-EVDatabaseDetail is provided by Symantec.EnterpriseVault.PowerShell.Core.dll, which is not imported automatically by the Enterprise Vault Management Shell. You must import this DLL module.
Set-EVDatabaseDetail -ServerName <string> -InputObject <string> [<CommonParameters>]
Table: Set-EVDatabaseDetail parameters
Parameter | Description |
|---|---|
-ServerName (required) | The name of the SQL server you are migrating to. This can be a listener, instance, server or virtual network name. |
-InputObject (required) | A valid DatabaseDetail object of type Symantec. EnterpriseVault.PowerShell.Core.Output.DatabaseDetail. See the help for Get-EVDatabaseDetail for a description of the properties of this object. |
Get-EVDatabaseDetail | where {$_.SQLInstanceName -eq 'SVR55\SQL1' } | Set-EVDatabaseDetail -ServerName AGlistener
Updates SQL server connection details for all databases on a specific SQL server instance "SVR55\SQL1" to use "AGlistener" listener. This example uses the Get-EVDatabaseDetail cmdlet as the pipeline input to the Set-EVDatabaseDetail cmdlet.
Get-EVDatabaseDetail | where {$_.type -eq 'directory'} | Set-EVDatabaseDetail -ServerName AGlistener
Updates the "SQLServer Name" for the "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Directory\DirectoryService" key on all Enterprise Vault servers to "AGlistener". This example uses the Get-EVDatabaseDetail cmdlet as the pipeline input to the Set-EVDatabaseDetail cmdlet.
New-Object -TypeName Symantec.EnterpriseVault.PowerShell.Core.Output.DatabaseDetail("SVR33", "EnterpriseVaultDirectory", 0) | Set-EVDatabaseDetail -ServerName AGlistener
Updates the "SQLServer Name" for the "HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\KVS\Enterprise Vault\Directory\DirectoryService" key on all Enterprise Vault servers from "SVR33" to "AGlistener". In this example we create a new object of type Symantec.EnterpriseVault.PowerShell.Core.Output.DatabaseDetail, setting the SQLInstanceName, DBName and Type mandatory properties as the pipeline input. Use this method for updating connection details if your EnterpriseVaultDirectory database server is no longer accessible.
Get-EVDatabaseDetail | where {$_.sqlservername -eq 'sql-svr1' -and $_.SQLInstanceName -ne 'AGlistener' -and $_.IsAccessible -eq 'true' } | Set-EVDatabaseDetail -ServerName AGlistener
Updates SQL server connection details for all accessible databases on a specific SQL server machine "sql-svr1" that do not currently use a listener to use "AGlistener" listener. This example uses the Get-EVDatabaseDetail cmdlet as the pipeline input to the Set-EVDatabaseDetail cmdlet.
None.
See Get-EVDatabaseDetail.
See Get-EVDatabase.
More Information