Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

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!