So you upgraded your MOSS 2007 farm to SharePoint 2010 instead of doing a new install? Yeah me too…ouch.
I had a database that didn’t get upgraded (MOSS_SSP_SEARCH_DB). I decided to rebuild the service applications where I could which included search. The object was still referenced in the configuration database and was creating a configuration error in the Health Analyzer.
Health Analyzer Configuration error
Database is too old and upgrade is required – SearchPropertyStoreDatabase
Use Upgrade-SPContentDatabase to upgrade Content databases, or psconfig.exe to upgrade other databases. If some databases are too new, check the Patch Status page to find out if the current server are missing SharePoint software patches.
Using SSMS I looked at the Configuration Database determine the object id.
SELECT id
,classid
,parentid
,name
,status
,version
,properties
FROM objects WITH(nolock)
WHERE name LIKE 'MOSS_SSP_SEARCH_DB'
Next I used STSADM on my application server to remove the reference.
stsadm -o deleteconfigurationobject -id "<object id>"
As a precaution I took the database offline to ensure there are no longer any dependencies. I made sure I deleted the database prior to the next scheduled backup.