SharePoint stores end-user content and application configurations across multiple relational databases in the back-end database servers. At a high level, the following are the relational databases:
Configuration database: Stores topology and configuration information for the complete deployment. Every farm has exactly one configuration database. For information about the configuration database protocols, see Configuration Database.
Central Administration content database: Stores content associated with the Central Administration site.
Shared Services Providers (SSP) database: Stores content and configuration for Shared Service Providers (SSPs), such as the user profile services. The capabilities of SSPs are described in [MS-SPFEPO], Section 2.2.2 (Shared Service Provider).
Shared services administration content database: Stores content for the shared services administration site.
Content database: Stores all end-user and site content. For information about content databases and protocols, see List and Library Storage.
Search property store: The search metadata index that stores properties related to pieces of content that are indexed for full-text querying. For information, see section 7.4.1.1.2.
11 of 43
[MS-SPBEPO] SharePoint Back-End Protocols Overview – v1.0
[MS-SPBEPO]: SharePoint Back-End Protocols Overview
Copyright © 2008 Microsoft Corporation.
Release: Friday, June 27, 2008
Single sign-on database: Stores credentials for end-users to access information from external applications through SharePoint. For information about the protocols used to access the single sign-on (SSO) database, see Business Data Catalog Protocols.
As described by Microsoft in SharePoint Back-End Protocols Overview
SharePoint stores end-user content and application configurations across multiple relational databases in the back-end database servers. At a high level, the following are the relational databases:
- Configuration database: Stores topology and configuration information for the complete deployment. Every farm has exactly one configuration database.
- Central Administration content database: Stores content associated with the Central Administration site.
- Shared Services Providers (SSP) database: Stores content and configuration for Shared Service Providers (SSPs), such as the user profile services.
- Shared services administration content database: Stores content for the shared services administration site.
- Content database: Stores all end-user and site content.
- Search property store: The search metadata index that stores properties related to pieces of content that are indexed for full-text querying.
- Single sign-on database: Stores credentials for end-users to access information from external applications through SharePoint.
