The Configuration, Central Administration Content, and
Content databases are the 3 databases that are automatically installed when you
deploy SharePoint 2013.
 
 
 
 
 
 
Please Reference the msdn article to get more: 
Category      
 | 
  
Data base Name 
 | 
  
Description 
 | 
 
Configuration database 
 | 
  
SharePoint_Config 
 | 
  
The configuration database contains data about the
  following: 
1. SharePoint databases 
2. Internet Information Services (IIS) web sites 
3. Web applications 
4. Trusted solutions 
5. Web Part packages 
6. Site templates 
7. Web applications 
The configuration database also contains specific
  data for SharePoint 2013 farm settings, such as default quota settings and
  blocked file types. 
 | 
 
Central administration database 
 | 
  
SharePoint_Admin_Content 
 | 
  
The Central Administration content database is considered to be a
  configuration database. It stores all configuration data for the Central
  Administration site collection. 
 | 
 
Content database 
 | 
  
WSS_Content 
 | 
  
A content database can be associated with more than
  one site collection. 
 | 
 
SharePoint 2013 service application databases:
The following service application databases are available in
both SharePoint Foundation 2013 and SharePoint Server 2013 deployments.
Category      
 | 
  
Data base Name 
 | 
  
Description 
 | 
 
App Management database 
 | 
  
AppManagement 
 | 
  
  
Used by the App Management Service application. It
  stores the app licenses and permissions that are downloaded from the
  SharePoint Store or App Catalog. 
 | 
 
Business Data Connectivity
  service application database 
 | 
  
Bdc_Service_ DB_<GUID>: 
 | 
  
Stores external content types and related objects. 
 | 
 
Secure Store Service database 
 | 
  
Secure_Store_Service_DB_<GUID> 
 | 
  
  
Stores and maps credentials, such as account names and
  passwords. 
 | 
 
Usage and Health Data Collection
  database 
 | 
  
SharePoint_Logging 
 | 
  
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. 
 | 
 
Subscription Settings Service database 
 | 
  
SettingsServiceDB 
 | 
  
SharePoint 2013 Search service application databases:
The Search service application has four databases that
support SharePoint 2013. The four Search service application databases are
shown in the following list. The tables that follow the list display the
relevant database information.
Category      
 | 
  
Data base Name 
 | 
  
Description 
 | 
 
Search Administration 
 | 
  
Search_Service_ Application_DB_<GUID> 
 | 
  
  
The Search Administration database hosts the Search
  service application configuration and access control list (ACL) for the crawl
  component. 
 | 
 
Analytics Reporting 
 | 
  
Search_Service_ Application_Analytics ReportingStoreDB_<GUID> 
 | 
  
  
The Analytics Reporting database stores the results for usage
  analysis reports and extracts information from the Link database when needed. 
 | 
 
Crawl 
 | 
  
Search_Service_Application_ CrawlStoreDB_<GUID>: 
 | 
  
Stores the state of the crawled data and the crawl
  history. 
 | 
 
Link 
 | 
  
Search_Service_ Application_LinkStore DB_<GUID> 
 | 
  
Stores the information that is extracted by the content processing
  component and the click through information. 
 | 
 
SharePoint Server 2013 databases:
Category      
 | 
  
Data
  base Name 
 | 
  
Description 
 | 
 
Word Automation Services service application
  database 
 | 
  
WordAutomationServices_<GUID> 
 | 
  
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. 
 | 
 
Managed Metadata Service application database 
 | 
  
Managed Metadata Service  Application_Metadata_<GUID> 
 | 
  
Stores
  managed metadata and syndicated content types. 
 | 
 
Taxonomy database ─ (Managed Metadata Service
  application) 
 | 
  
Managed Metadata  Service_<GUID> 
 | 
  
Stores a hierarchical structure for items that are used for
  tagging content and building site collections. This database works in
  conjunction with the Managed Metadata Service that provides the Term Store
  Management Tool in the SharePoint Central Administration website. 
 | 
 
SharePoint Translation Services service
  application database 
 | 
  
SharePoint Translation  Services_<GUID> 
 | 
  
Stores
  information about pending and completed batch document translations with file
  extensions that are enabled. 
 | 
 
Project Server service application database 
 | 
  
ProjectWebApp 
 | 
  
Project Server creates a separate database for each instance
  of Project Web App. Each Project Web App database contains the following
  data: 
All Project and Portfolio Management (PPM) data 
Time tracking and Timesheet data 
Aggregated SharePoint project site data 
 | 
 
SQL Server PowerPivot Service application database 
 | 
  
DefaultPowerPivotService ApplicationDB_<GUID> 
 | 
  
Stores
  data refresh schedules, and PowerPivot usage data that is copied from the
  central usage data collection database. 
Note:  
1. SQL Server 2012 PowerPivot for SharePoint 2013 requires SQL Server
  2012 Analysis Services (SSAS), Business Intelligence or Enterprise edition. 
2. When being used, PowerPivot stores additional data in content
  databases and in the Central Administration Content database (WSS_Content). 
 | 
 
PerformancePoint Services service application
  database 
 | 
  
PerformancePoint Service _<GUID> 
 | 
  
Stores temporary objects and persisted user comments and
  settings. 
 | 
 
State Service application database 
 | 
  
SessionStateService_<GUID> 
 | 
  
Stores
  temporary state information for InfoPath Forms Services, Exchange Server, the
  chart Web Part, and Visio Services. 
 | 
 
SharePoint User Profile service application databases:
Category      
 | 
  
Data
  base Name 
 | 
  
Description 
 | 
 
Profile DB 
 | 
  
User Profile Service  Application_ProfileDB_<GUID> 
 | 
  
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. 
 | 
 
Synchronization DB 
 | 
  
User Profile Service  Application_SyncDB_<GUID> 
 | 
  
The Synchronization database stores configuration and staging data
  for use when profile data is being synchronized with directory services such
  as Active Directory. 
 | 
 
Social Tagging DB 
 | 
  
User Profile Service  Application_SocialDB_<GUID> 
 | 
  
The Social Tagging database stores social tags and notes created by
  users, alongside their respective URLs. 
 | 
 
Please Reference the msdn article to get more:
No comments:
Post a Comment