Highlighted

Enterprise Vault Upgrade Monitoring Database Failed

Dear Team,

I am getting below error message when i upgrade enterprise vault 12.0 database

EnterpriseVaultMonitoring: Could not be upgraded. Database remains on version'7.4.8.5.0'. The database cannot be upgraded while other users are connected:There is one SQL connection open on this database from the computer 'EV'from program 'Microsoft SQL Server Management Studio' run by 'xxxxx\evadmin'.

 

Some databases could not be upgraded:

The Audit Database was upgraded successfully to '3.2.0.1.0'
The Directory Database was upgraded successfully to '12.24.6.207.0'
The Monitoring Database failed to upgrade from '7.4.8.5.0' to '12.1.0.9.0'

thanks

sandeepk

6 Replies
Highlighted

Re: Enterprise Vault Upgrade Monitoring Database Failed

i need your help......

Highlighted

Re: Enterprise Vault Upgrade Monitoring Database Failed

Did you try closing SQL Management Studio?

For the best O365 Reporting Solution click here Radar-Reporting
Highlighted

Re: Enterprise Vault Upgrade Monitoring Database Failed

Dear Tony,

thanks for reply..

after closing SQL Management Studio we are getting same error message. also we have put database in singlae user mode but no luck.. 

Highlighted

Re: Enterprise Vault Upgrade Monitoring Database Failed

Hi,

did you check for open sessions sql wise? Query active connections with sql.

Re: Enterprise Vault Upgrade Monitoring Database Failed

you can run the query 'exec sp_who' and 'exec sp_who2' to find out what open connections you have to the db. you could also look at activity monitor if you needed to.

Highlighted

Re: Enterprise Vault Upgrade Monitoring Database Failed

You can view all the SQL transactions with SQL activity monitor. If all of you EV services are stopped you should not see any transactions running. You probably have orphaned/stale transactions that need to be killed.

This happens when there is a connection made to that database which you will see in the activity monitor