Problem Description:
The SharePoint Health Analyzer detected an error. Content databases contain orphaned items.
In
some situations, a content database that is used by Microsoft
SharePoint Foundation may become corrupted. The corrupted database may
contain orphaned items. For example, a document may not have a parent
document library or a list may not have a parent Microsoft SharePoint
Foundation Web site. Consequently,
you may be unable to create new items with the same URL as the orphaned
items, and space in the content database will be consumed
unnecessarily.
Error Message:
Content databases contain orphaned items
Resolution:
Perfect article provided by Microsoft on this which helps me to resolve this issue:
http://technet.microsoft.com/en-in/library/ff805076(v=office.14).aspx
Product Applies To:
SharePoint Server 2010.
SharePoint Foundation 2010.