Different database in SharePoint 2013

In this post we will discuss about different database in SharePoint 2013 deployments. Also you can check out some articles on:

- Continuous Crawl in SharePoint 2013 search

- Steps to create a task list in SharePoint 2013

- Follow or UnFollow people by using SharePoint 2013 client object model

There are 3 types of databases installed when you deploy SharePoint 2013 and they are: Configuration database, Central Administration Content and Content database.

Configuration database:

The configuration database contains data about:

- SharePoint databases

- Internet Information Services (IIS) web sites

- Web applications

- Trusted solutions

- Web Part packages

- Site templates

- Web applications

Also it contains information about default quota settings and blocked file types etc.

The default database name when it is installed with the SharePoint Products Configuration Wizard is: SharePoint_Config


Central Administration content database:

Central Administration content database stores all configuration data for the Central Administration site collection.

The default database name prefix when it is installed by using the SharePoint Products Configuration Wizard is SharePoint_Admin_Content.

Content databases:

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.

The default database name when installed by using the SharePoint Products Configuration Wizard is WSS_Content. Followed from technet article.

Posted in SharePoint 2013