Search This Blog

Thursday, October 24, 2013

How many databases are created when SharePoint is installed?

There are 3 types of databases installed when you deploy SharePoint 2010/2013 and they are:
 Configuration database, Central Administration content database 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.

Reference: Technet

No comments:

Post a Comment