Share via

SharePoint 2010: Database Anatomy

  • Article

This is a look at all the SharePoint databases and the table and field anatomy of each.

SharePoint Foundation 2010

  • [[SharePoint_Config]]
  • [[SharePoint_AdminContent]]
  • [[WSS_Content]]
  • [[WSS_UsageApplication]]
  • [[BDC_Service_DB_]]
  • [[Application_Registry_Server_DB_]]
  • [[SubscriptionSettings_]]

SharePoint Server 2010 - Standard Edition

  • [[Secure_Store_Services_DB_]]
  • [[StateService]]
  • [[WebAnalyticsServiceApplication_StagingDB_]]
  • [[WebAnalyticsServiceApplication_ReportingDB_]]
  • [[Search_Service_Application_DB_]]
  • [[Search_Service_Application_CrawlStoreDB_]]
  • [[Search_Service_Application_PropertyStoreDB_]]
  • [[User Profile Service Application_ProfileDB_]]
  • [[User Profile Service Application_SyncDB_]]
  • [[User Profile Service Application_SocialDB_]]
  • [[Managed Metadata Service_]]
  • [[WordAutomationServices_]]

SharePoint Server 2010 - Enterprise Edition

  • [[PerformancePoint Service Application_]]

Project Server 2010

  • [[ProjectServer_Draft]]
  • [[ProjectServer_Published]]
  • [[ProjectServer_Archive_]]
  • [[ProjectServer_Reporting]]

Fast Search Server for SharePoint 2010

  • [[FASTSearchAdminDatabase]]

PowerPivot for SharePoint

  • [[DefaultPowerPivotServiceApplicationDB]]