SharePoint 2010: Database names

SharePoint 2010: Database names


The following databases are used in a SharePoint 2010 installation:

  • Crawl database

The Crawl Database name and server name can be obtained from the Search Application Topology section in Central Admin.

 

 

The Crawl database contains the following tables:


  • MSSActiveCrawls
  • MSSAnchorChangeLog
  • MSSAnchorDocPropsBlob
  • MSSAnchorDocPropsBlobTrace
  • MSSAnchorPendingChangeLog
  • MSSAnchorText
  • MSSAnchorTextPrepState
  • MSSAnchorTextPrepStateLog
  • MSSAnnotations
  • MSSAnnotationsPending
  • MSSAnnotationsPendingStatus
  • MSSBatchHistory
  • MSSChangeLogCookies
  • MSSCompletedCrawls
  • MSSConfiguration
  • MSSCrawlChangedCommittedDocs
  • MSSCrawlChangedDeletedDocs
  • MSSCrawlChangedSourceDocs
  • MSSCrawlChangedTargetDocs
  • MSSCrawlComponentsLocal
  • MSSCrawlDeletedErrorList
  • MSSCrawlDeletedURL
  • MSSCrawlErrorList
  • MSSCrawlHostList
  • MSSCrawlHostsLog
  • MSSCrawlLinksLog
  • MSSCrawlQueue
  • MSSCrawlReportCrawlErrors
  • MSSCrawlURL - There are two tables that can assist in looking at Crawl log information. Both MSSCrawlURLLog and MSSCrawlURL contain information gathered during a crawl. Please update this page with details that describe the differences between these two tables and why you might use one versus the other. This table may be necessary to reference because there are no exposed api calls to obtain details on the crawl.
  • MSSCrawlUrlChanges
  • MSSCrawlURLLog  - There are two tables that can assist in looking at Crawl log information. Both MSSCrawlURLLog and MSSCrawlURL contain information gathered during a crawl. Please update this page with details that describe the differences between these two tables and why you might use one versus the other. This table may be necessary to reference because there are no exposed api calls to obtain details on the crawl.
  • MSSCrawlUrlReport
  • MSSCrawlUrlUsedContentSourceReport
  • MSSCrawlUrlUsedErrorReport
  • MSSDiscoveredLinks
  • MSSDocDeleteList
  • MSSNextDocID
  • MSSOrdinal
  • MSSRowOrdinal
  • MSSSocialDistance
  • MSSSocialDistanceLinkDelete
  • MSSSocialDistanceLinkNew
  • MSSSocialDistanceLinkUnchanged
  • MSSTranTempTable0
  • MSSTranTempTable1
  • MSSUserHosts
  • MSSUserIDDocIDMap
  • Versions
Leave a Comment
  • Please add 6 and 6 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Fernando Lugão Veltem edited Revision 2. Comment: remove en-us from title

  • Craig Lussier edited Revision 1. Comment: added en-US to tags and title

  • Ed Price MSFT edited Original. Comment: Updated title. Added tag.

Page 1 of 1 (3 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Ed Price MSFT edited Original. Comment: Updated title. Added tag.

  • As of today, Oct 1st 2011, this article really needs some work....

  • Craig Lussier edited Revision 1. Comment: added en-US to tags and title

  • Fernando Lugão Veltem edited Revision 2. Comment: remove en-us from title

  • Craig, such as...? More databases? More info for each database? More intro or how to info?

  • Ed - Although I made the comment quite some time ago, if this wiki was intended to be a listing of databases and corresponding tables related to a SharePoint 2010 installation, then there are a lot of databases to be included. If this was intended to be specific to the Crawl database only, I'd suggest changing the wiki title (which through past experience I know authors are not keen on having others change :)

Page 1 of 1 (6 items)