SharePoint Databases Knowledge Base

SharePoint depends on databases for everything: without a healthy SQL Server installation, SharePoint will not work at all.  As part of it’s dependence on SQL Server, SharePoint creates multiple databases when it is installed and when new service applications are created, more databases are created and finally, SharePoint Administrator’s can create new databases to store content in.

The characteristics of these databases vary quite dramatically, based on many different criteria including the following:

  • Location and speed of storage within SQL Server
  • Usage of the SharePoint farm
  • Approach taken towards High Availability and Disaster Recovery for SharePoint
  • Approach taken towards High Availability and Disaster Recovery for SQL Server

A SharePoint farm is not an isolated entity, it is an ecosystem of different products related to infrastructure and software and as a result, there are databases required for multiple different elements.  This list of databases relates to the following products:

  • SharePoint 2013
  • SQL Server
  • SQL Server Reporting Services
  • Project Server 2013
  • Workflow Manager
  • Office Web Apps

Each of the Databases has a page that provides information specific to the database.

I have collated the guidance that Microsoft provide from both SQL and SharePoint perspectives to have a page per database that provides the following information:

  • Description of the purpose of the database
  • Guidance for sizing and growth
  • Disaster and High Availability recommendations
  • Links to PowerShell for creating the databases with tidy names
  • Other information useful to planning the size of a database
Product Service Application Default DB Name Link
SharePoint   SharePoint_Config Go
SharePoint   SharePoint_AdminContent_<GUID> Go
SharePoint   WSS_Content Go
SharePoint App Management AppManagement Go
SharePoint Business Connectivity Services Bdc_Service_DB_<GUID> Go
SharePoint Managed Metadata Service Managed Metadata Service Application_Metadata_<GUID> Go
SharePoint PerformancePoint Services PerformancePoint Service _<GUID> Go
SharePoint PowerPivot DefaultPowerPivotServiceApplicationDB_<GUID> Go
SharePoint Project Server ProjectWebApp Go
SharePoint Search Search_Service_Application_DB_<GUID> Go
SharePoint Search Search_Service_Application_ AnalyticsReportingStoreDB_<GUID> Go
SharePoint Search Search_Service_Application_CrawlStoreDB_<GUID> Go
SharePoint Search Search_Service_Application_LinkStoreDB_<GUID> Go
SharePoint Secure Store Secure_Store_Service_DB_<GUID> Go
SharePoint State Service SessionStateService_<GUID> Go
SharePoint Subscription Settings Service SettingsServiceDB Go
SharePoint SharePoint Translation Services SharePoint Translation Services_<GUID> Go
SharePoint User Profile Service User Profile Service Application_ProfileDB_<GUID> Go
SharePoint User Profile Service User Profile Service Application_SocialDB_<GUID> Go
SharePoint User Profile Service User Profile Service Application_SyncDB_<GUID> Go
SharePoint Usage and Health SharePoint_Logging Go
SharePoint Word Automation Services WordAutomationServices_<GUID> Go
Workflow Manager Service Bus SB_Gateway Coming Soon
Workflow Manager Service Bus SB_Management Coming Soon
Workflow Manager Service Bus SB_MessageContainer01 Coming Soon
Workflow Manager   WFM_InstanceManagement Coming Soon
Workflow Manager   WFM_Management Coming Soon
Workflow Manager   WFM_ResourceManagement Coming Soon
SQL Server Reporting Services ReportingService_<GUID>_TempDB Coming Soon
SQL Server Reporting Services ReportingService_<GUID> Coming Soon
SQL Server Reporting Services ReportingService_<GUID>_Alerting Coming Soon
SQL Server   Master Coming Soon
SQL Server   MSDB Coming Soon
SQL Server   Model Coming Soon
SQL Server   TempDB Coming Soon
SQL Server   Resource Coming Soon

The information that has been used to create this knowledge base can be found in the following pages:

Microsoft Products – References

SharePoint Databases – References