SharePoint 2016, Sharepoint 2013, Sharepoint 2010, Windows Server 2012, Sql Server 2012,2014,IIS, Active Directory,User Profile Service, Managed MetaData Service, Search Service, Topology, Web Application, IIS, Site collection, List, Library, PowerShell, office web app, Windows Authentication, NTLM, Kerberos, Saml, ADFS, Active Directory Import, MIM, SharePoint 2016 Central Admin –Application Management – Manage Content Database – SharePoint

SharePoint 2016 Central Admin –Application Management – Manage Content Database

Manage Content Database (Direct Link /_admin/defaultcontentdb.aspx)

When you click on the Manage Content Database Link, you will be landed on Content Database page. This page will let you add new content database or remove a content database from this web application. You will also set the properties of the content database i.e changing the database status, maximum number of sites or warning limit etc.


Content Database page will let SharePoint administrator manage the content databases of the web applications. The administrator can create new content Databases, remove the existing content database from the web application, take the database offline, set the maximum number of the site collection and warning level of a content database.

On this page you will get the following information:

  • Database name: This will list the name of the content database for the web application in selection
  • Database Status: this column will tell the status of the database whether it is started or stopped. Stop status means no new site collection can be provision in this content database. User profile sync also stops working once the content database status is offline, which means user information list will not be updated.
  • Database Read Only: This column will tell the status of the content database if it is a read-only state at SQL server.
  • Current Number of site collections: This column will tell how many site collections currently provisioned in this content database
  • Site collection level warning: this will tell the what is the warning level set for the content database. If the number of site collection reach to that number, then the owner will get the alert.
  • Maximum number of the site collection: This will tell; how many site collections can be provisioned in this content database. We can set the maximum number of the site collection to a valid number as per our requirement.
  • Preferred timer server: This will tell if there is any preferred server associated with his content database. This option is configurable, if for some reason we want to run all timer jobs related to a content database for a specific server then we can set it.
  • Web Applications: from this option, you can switch between the web applications

Add New Content Database

With add options, you can either add an existing content database to the web application or create a brand new content database. When you enter the required information, SharePoint check on the SQL if a valid SharePoint database exists with the same name it will add it otherwise it will provision brand new content database. To create a new content database Please follow the steps below.

  • Log on with farm admin account and browse to content database page
  • Click on the Add a Content Database
  • On this page enter the following information:
    • Web Application: Make sure correct web application is selected
    • Database Server: Specify the DB server name i.e. Kf-SQL
    • Database Name: Specify the Database Name I.e. Team_ContentDB
    • Database Authentication: Select between Windows or SQL Authentication. For windows authentication no need to give the credentials.
    • Failover Database Server: if you are using the mirroring then you can provide the fail over server. In our case No, so leave it blank.
    • Number of sites before warning event generated: Enter the number after that warning event generated.
    • Maximum Number of Site that can be created in this database: Enter the maximum number of site collections you want to be provisioned in this DB. In our case, we will use default i.e 5000
  • Click OK.

Remove a Content Database

In order to remove a content database, you have to follow the below instruction.

  • Log on with farm admin account and browse to content database page
  • Click on the Content Database Name (which you want to remove)
    • Make Sure You Select the correct Web Application
    • Click on the Correct Database

  • On Manage Content Database Settings Page.
    • Make Sure the Database Server and DB name one more time as mention in the picture
    • In Remove Content Database Section, Please Check the Check Box
    • Click Ok.
    • On this page you will see that Team_ContentDB is no more listed in SharePoint.

Change the Properties of a Content Database

In order to change the properties of a content database, you have to follow the below instruction.

  • Log on with farm admin account and browse to content database page
  • Click on the Content Database Name (which you want to remove)
  1. Make Sure You Select the correct Web Application
  2. Click on the Correct Database
  • On Manage Content Database Settings Page. You change a couple of things.
    • To Change Database Status from Ready to Offline.
      • From the Database Status Drop, Select the Offline and Click OK.
      • On next page, you will see the Team_ContentDB’s Status is offline.
    • To Change the Maximum Number of Site Collections & Warning Level.
      • In the Database Capacity Settings, Enter the number in the warning Text box and Higher Number for the Maximum Sites text box. ( Make Sure the Warning level is always lower than maximum i.e in our example, 90 for warning and maximum Sites will be 100). Click Ok
      • On next page, you will the Site collection Level Warning value is change to 90 and Maximum Number of Site collection value also set as 100.
    • To Change the Proffered Server for the Timer Jobs.
      • On the Database Settings page, in the Proffered Server for Timer Jobs section click on the dropdown and Select the server you want to use. ( we want to use KF-SP). Click Ok.
      • On Content Database Page, you will see the KF-SP listed as preferred Timer Server


You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *