Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

EV 10 migration issue

Created: 04 Mar 2013 • Updated: 05 May 2013 | 7 comments
This issue has been solved. See solution.

 1. Created a migration package and verified report.

 
 Enterprise Vault monitoring & FSA reporting are pointing to the server that
 does not exist, how to remove Enterprise Vault monitoring & FSA reporting  From EV?

Comments 7 CommentsJump to latest comment

JesusWept3's picture

when you say pointing to a server that doesn't exist, can you explain a bit more?
is it throwing events to the wrong server name? if so can you paste them?

rajesh velagapudi's picture

EV Server Migration report

----------------------------------------

Data location to transition

SQL Server Databases

Database Name Database Type Location Transition Required
EnterpriseVaultDirectory Directory SQLserver1 No
A Storage SQLserver1 No
B Storage SQLserver1 No
C Storage SQLserver1 No
EnterpriseVaultMonitoring Monitoring SQLserver2 No
EnterpriseVaultFSAReporting FSA Reporting Database SQLserver2 No

 SQLServer2 dose not exist.

I ran Server settings migration tool on targert server, I was not able to proceed further because EnterpriseVaultMonitoring & EnterpriseVaultFSAReporting status are showing as failed, there is no problem with other databases.

Logs

-------------

3/4/2013 10:37:52 AM Database EnterpriseVaultMonitoring schema version is invalid

3/4/2013 10:38:35 AM Connection to database EnterpriseVaultFSAReporting using SQL instance SQLserver2 failed.

EnterpriseVaultMonitoring & EnterpriseVaultFSAReporting database are pointing to the SQL server (SQLserver2) that dose not exist.

I wanted to remove/disable EnterpriseVaultMonitoring & EnterpriseVaultFSAReporting and run EV server migration tool on EV source servers again.

How to to remove/disable EnterpriseVaultMonitoring & EnterpriseVaultFSAReporting?

TonySterling's picture

So do the EnterpriseVaultMonitoring and EnterpriseVaultFSAReporting exist on SQLServer1?

Can you run these sql queries agianst the EnterpriseVaultDirectory Database?

Select *
FROM MonitoringSettings

Select *
FROM FSAReportingDatabase

rajesh velagapudi's picture

Select *
FROM MonitoringSettings

DatabaseDSN    SQLServer     SQLprotocol   SQLDSNtype    Database name            Schema version

NULL           SQLserver2 TCP/IP      NULL        EnterpriseVaultMonitoring  7.0.0.0

Select *
FROM FSAReportingDatabase

FSAreportingdatabaseID     SQLServer   SQLprotocol    Database name                     Schema version

1                    SQLserver2 TCP/IP       EnterpriseVaultFSAReporting 7.0.0.0

TonySterling's picture

So are those databases located on SQLServer1?

SOLUTION
JesusWept3's picture

well theres your answer!