Enterprise Vault Upgrade Monitoring Database Failed

[sandeepk]

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

[sandeepk]

i need your help......

[TonySterling]

Did you try closing SQL Management Studio?

[sandeepk]

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.. 

[CConsult]

Hi,

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

[AndrewB]

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.

[JimmyNeutron]

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