Sharepoint 2010: 2 service application databases with the same name showing in Central Admin –> Manage Databases Upgrade Status

By peter.stilgoe









I had a strange problem where if I went into:

Central Admin –> Manage Databases Upgrade Status

in Sharepoint 2010 I had 2 Business Data Connectivity Service databases with the same name! The status of the one in use was ‘No action required’ & the rogue one had ‘Database is too old and upgrade is required’

There was only one database showing on the SQL server, the one in use, if you find you get 2 service application databases with the same name (somehow!?) the command to delete it is:

Stsadm -o deleteconfigurationobject -id b9b3e713-9e53-42ab-a634-a2c54e90a0d6

(replace the guid with the rogue database guid)

More From pstilgoe

Blog Margeting Related Posts Plugin For pstilgoeAsk pstilgoe To Recommend Your Posts Blog Marketing Related Posts Plugin Counter

Share

, , ,

About... peter.stilgoe

peter.stilgoeThis author published 497 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant









Share

FacebookTwitterEmailWindows LiveTechnoratiDeliciousDiggStumbleponMyspaceLikedin

1 Comment

  • At 2011.05.12 08:15, Mark said:

    I would like to share with you a 6 day certification boot camps which can help you to obtain SharePoint 2010 certifications for both administrator and developers.

    If you want to know more you can visit @ http://www.campsharepoint.com/ and learn more about the upcoming conferences.

    [Reply]

    [Reply]
    (Required)
    (Required, will not be published)