Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (Microsoft)
  • When: 25 Feb 2011 3:59 PM
  • Last revision by (eMicrosoft Partne)
  • When: 12 Jun 2013 4:22 AM
  • Revisions: 6
  • Comments: 6
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  SharePoint 2010: Database names

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
, , , , [Edit tags]
Leave a Comment
  • Please add 2 and 7 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 7 May 2013 1:47 PM

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

  • 18 Feb 2012 11:19 AM

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

  • 2 Mar 2011 3:55 PM

    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
  • Posted by
    on 2 Mar 2011 3:55 PM

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

  • Posted by
    on 1 Oct 2011 4:01 PM

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

  • Posted by
    on 18 Feb 2012 11:19 AM

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

  • Posted by
    on 7 May 2013 1:47 PM

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

  • Posted by
    on 21 May 2013 6:16 PM

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

  • Posted by
    on 21 May 2013 8:22 PM

    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)