I am getting below error message when i upgrade enterprise vault 12.0 database
EnterpriseVaultMonitoring: Could not be upgraded. Database remains on version'18.104.22.168.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 '22.214.171.124.0'
The Directory Database was upgraded successfully to '126.96.36.199.0'
The Monitoring Database failed to upgrade from '188.8.131.52.0' to '184.108.40.206.0'
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..
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.
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