Following is the list of SharePoint 2013 databases. This list will help you to understand architecture of the SharePoint. Perhaps, you will know what information is being stored and in which database.

Area: configuration

Database Name:SharePoint_Config

Contain Information about:

The configuration database contains data about the following:

  • SharePoint databases
  • Internet Information Services (IIS) web sites
  • Web applications
  • Trusted solutions
  • Web Part packages
  • Site templates
  • Web applications

 

Area: Central Administration content

Database Name:SharePoint_AdminContent_<GUID>

Contain Information about:

The Central Administration content database is considered to be a configuration database. It stores all configuration data for the Central Administration site collection. If SQL Server 2012 Power Pivot for SharePoint 2013 is installed, the Central Administration content database also stores the Excel worksheets and Power Pivot data files used in the Power Pivot Management Dashboard. Note that Power Pivot for SharePoint 2013 can only be installed on SharePoint Server 2013.

Area: Content databases

Database Name: WSS_Content

Contain Information about:

Content databases store all content for a site collection. This includes site documents or files in document libraries, list data, Web Part properties, audit logs, and sandboxed solutions, in addition to user names and rights.

All of the files that are stored for a specific site collection are located in one content database on only one server. A content database can be associated with more than one site collection.

Content databases also store user data for Power Pivot for SharePoint, if you installed it in your SharePoint Server 2013 environment. Note that Power Pivot for SharePoint can only be installed on SharePoint Server 2013

 

Area: App Management database

Database Name: AppManagement

Contain Information about:

The App Management database is used by the App Management Service application. It stores the app licenses and permissions that are downloaded from the SharePoint Store or App Catalog.

 

Area: Business Data Connectivity service application database

Database Name: Bdc_Service_DB_<GUID>

Contain Information about:

The Business Data Connectivity service application database stores external content types and related objects.

 

Area:Search Administration database

Database Name: Search_Service_Application_DB_<GUID>

Contain Information about:

The Search Administration database hosts the Search service application configuration and handles crawl state orchestration, including the content source crawl history.

 

Area:Analytics Reporting database

Database Name:

Search_Service_Application_AnalyticsReportingStoreDB_<GUID>

Contain Information about:

The Analytics Reporting database stores the results for usage analysis reports and extracts information from the Link database when needed.

 

Area:Crawl database

Database Name:

Search_Service_Application_CrawlStoreDB_<GUID>

Contain Information about:

The Crawl Store database stores the state of each crawled item and provides the crawl queue for items currently being crawled.

 

Area:Link database

Database Name:

Search_Service_Application_LinkStoreDB_<GUID>

Contain Information about:

The Link database stores the information that is extracted by the content processing component and the click through information.

 

Area:Secure Store Service database

Database Name: Secure_Store_Service_DB_<GUID>

Contain Information about:

The Secure Store Service application database stores and maps credentials, such as account names and passwords.

 

Area:Usage database

Database Name: SharePoint_Logging

Contain Information about:

The Usage and Health Data Collection database is used by the Usage and Health Data Collection service application. It stores health monitoring and usage data temporarily, and can be used for reporting and diagnostics. The Usage and Health Data Collection database is the only SharePoint database that supports schema modifications.

 

Area:Subscription Settings Service database

Database Name: SettingsServiceDB

Contain Information about:

The Microsoft SharePoint Foundation Subscription Settings service application database stores features and settings for hosted customers. The Subscription Settings service application and database are not created by the SharePoint Products Configuration Wizard  they must be created by using Windows PowerShell cmdlets or SQL Server. For more information.

 

Area:Profile database

Database Name: User Profile Service Application_ProfileDB_<GUID>

Contain Information about:

The Profile database stores and manages users and associated information. It also stores information about a user’s social network in addition to memberships in distribution lists and sites.

 

Area:Synchronization database

Database Name: User Profile Service Application_SyncDB_<GUID>

Contain Information about:

The Synchronization database stores configuration and staging data for use when profile data is being synchronized with directory services such as Active Directory.

 

Area:Social Tagging database

Database Name: User Profile Service Application_SocialDB_<GUID>

Contain Information about:

The Social Tagging database stores social tags and notes created by users, alongside their respective URLs.

 

Area:Word Automation Services service application database

Database Name: WordAutomationServices_<GUID>

Contain Information about:

The Word Automation Services database stores information about pending and completed document conversions and updates. The Word Automation Services Timer Job processes and distributes this information as queued conversion job items to application servers.

 

Area:Managed Metadata Service service application database

Database Name: Managed Metadata Service Application_Metadata_<GUID>

Contain Information about:

The Managed Metadata service application database stores managed metadata and syndicated content types.

 

Area:SharePoint Translation Services service application database

Database Name: SharePoint Translation Services_<GUID>

Contain Information about:

The Machine Translation Services stores information about pending and completed batch document translations with file extensions that are enabled.

 

Area:Project Server service application database

Database Name: ProjectWebApp

Contain Information about:

Project Server creates a separate database for each instance of Project Web App. Each Project Web App database contains the following data:

 

Area:SQL Server Power Pivot Service service application database

Database Name:

DefaultPowerPivotServiceApplicationDB_<GUID>

Contain Information about:

The Power Pivot Service database stores data refresh schedules, and Power Pivot usage data that is copied from the central usage data collection database

 

Area:PerformancePoint Services service application database

Database Name: PerformancePoint Service _<GUID>

Contain Information about

The PerformancePoint Services database stores temporary objects and persisted user comments and settings.

 

Area:State Service service application database

Database Name: SessionStateService_<GUID>

Contain Information about

The State Service database stores temporary state information for InfoPath Forms Services, Exchange Server, the chart Web Part, and Visio Services.

 

Area:master database

Database Name: master

Contain Information about

The master database records all the system-level information for a SQL Server instance. This includes logins, configurations, and other databases

 

Area:model database

Database Name: model

Contain Information about

The model database is used as the template for all databases created on the SQL Server instance. Any modifications made to the model database are also applied to all databases created afterward.

 

Area:msdb database

Database Name:msdb

Contain Information about

The msdb database is used by SQL Server Agent for scheduling alerts and jobs.

 

Area:tempdb database

Database Name:tempdb

Contain Information about

The tempdb database holds temporary objects or intermediate result sets. For example, it holds all temporary tables, temporary stored procedures, and any other temporary storage needs. The tempdb is recreated every time SQL Server starts.

 

Area:Report Server Catalog database

Database Name:

ReportingService_<GUID>

Contain Information about

The SQL Server Reporting Services Report Server Catalog database stores all report metadata including report definitions, report history and snapshots, and scheduling information. When Report Server Catalog is used, report documents are stored in SharePoint content databases.

 

Area:ReportServerTempDB database

Database Name:ReportingService_<GUID>_TempDB

Contain Information about

The SQL Server Reporting Services ReportServerTempDB database stores all the temporary snapshots while reports are running.

 

Area:Report Server Alerting database

Database Name:

ReportingService_<GUID>_Alerting

Contain Information about

The Report Server Alerting database stores all Data Alerts metadata and runtime information that is required to produce Data Alerts for Reporting Services operational reports. Data from reports is processed in the database to match rules that are defined in Alert Definitions.