cancel
Showing results for 
Search instead for 
Did you mean: 

EV 10 migration issue

rajesh_velagapu
Level 4

 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?

1 ACCEPTED SOLUTION

Accepted Solutions

TonySterling
Moderator
Moderator
Partner    VIP    Accredited Certified

So are those databases located on SQLServer1?

View solution in original post

7 REPLIES 7

JesusWept3
Level 6
Partner Accredited Certified

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?

https://www.linkedin.com/in/alex-allen-turl-07370146

rajesh_velagapu
Level 4

 

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
Moderator
Moderator
Partner    VIP    Accredited Certified

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_velagapu
Level 4

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
Moderator
Moderator
Partner    VIP    Accredited Certified

So are those databases located on SQLServer1?

rajesh_velagapu
Level 4

Yes

 

Regards

Rajesh

JesusWept3
Level 6
Partner Accredited Certified

well theres your answer!

https://www.linkedin.com/in/alex-allen-turl-07370146