03-04-2013 09:58 AM
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?
Solved! Go to Solution.
03-04-2013 12:09 PM
So are those databases located on SQLServer1?
03-04-2013 10:18 AM
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?
03-04-2013 11:24 AM
EV Server Migration report
----------------------------------------
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?
03-04-2013 11:50 AM
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
03-04-2013 12:07 PM
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
03-04-2013 12:09 PM
So are those databases located on SQLServer1?
03-04-2013 12:18 PM
Yes
Regards
Rajesh
03-04-2013 02:56 PM
well theres your answer!