Database is too old upgrade is required

  • Article

Issue:

Unable to Upgrade SP_SearchDB after Service pack 1 and FEB 2011 CU.

clip_image001

Background:

After installing the FEB CU 2011, we have successfully completed the configuration wizard. However the SPSearch database was not updated. “Database is too old and upgrade is required”

Customer Environment:

· Microsoft SharePoint 2010

· 1 APP/WFE

· Windows server 2008

Cause:

The help search database was out of sync and hasn’t been used in the environment..

Resolution

· Ran the following Psconfig command line and the issue was still exist:

Psconfig -cmd upgrade -inplace b2b -wait -force

· Checked the database upgrade status and noticed there are two database for “SPSearchDatabase”.

clip_image002

· Found that the “SharePoint Foundation Help Search” was using different database:

clip_image003

· Ran the “stsadm –o sync –listdatabase 1” and found that the database is last updated on January 2012.

· Confirmed that the DB is not being used and decided to remove from the farm.

· Ran the following PowerShell cmdlets to get the database GUID “Get-SpDatabase”.

· Using the GUID delete the config object by running the following command “Stsadm –o deleteconfigurationobject <GUID>”

· After that the database is removed from the upgrade database status page:

clip_image004

Hope this helps!

Cheers

Bala