SharePoint 2010 Upgrade – Database is too old and upgrade is required

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>