In this article, we will see how to manage the content database in SharePoint 2013 Central Admin. This configuration allows you to add or edit new content databases on Central Admin portal.
This configuration allows you to connect the content from different database like SQL to the Web Applications and makes the database content available on Central Admin.
These services can be managed, as per the governance of your organization.
How to configure it?
Let’s open Central Admin of SharePoint on your machine. On your Windows desktop screen, click Start >> Administrative Tools >> SharePoint 2013 Central Administration.
Run it as an administrator to have the elevated privileges.
You will see the screenshot given below.
Central Admin is configured under the categories given below.
Click Application Management.
Go to Databases
Click Manage Content Databases.
You will see the screen, as shown below.
Here, you can configure the content databases, whereas you can edit new databases and connect to the central administration.
This will provide you a view in the name of the database, status, read only or not, number of site collections under the Web, site collection warning level, max number of the site collection level and the preferred time server of the content database configuration.
Add a content database:
Web Application Choose a Web Application, where you would like to attach the content database.
Database Name and Authentication
Database Server- Provide the server detail.
Database name- Provide the database name.
Database authentication- Here, you can select the authentication as you want in Windows authentication or SQL authentication. This connection will be used to connect to the database.
Failover Server Here, you can use the mirror Server to be used as a back-up Server for the main Server.
Database Capacity Settings Here, you can configure the capacity of the Server, which will set the limit to the number of the sites that should be created or limited to send a warning when a certain amount of sites have been created.
Once you configure the database, click OK.
The database will be connected to your Web Application and to all the sites under the Web.
In this article, we saw how to manage content database on the Central Administration. There are more articles to come on Central Administration. Until then keep reading and keep learning.