create add a content database is the most common and frequent task in sharepoint 2019 for an administrator. Tasks during sharepoint migration, database upgrade, back up restore of content database, admin follows one of task to add a content database in web application. We can follow manual process of feom sharepoint central admin Ui method or by using powershell. So in this post will discuss how to create content database.
For Particular Requirement, client want to dedicate a database for a single site collection. When we create a site collection from central admin, site is placed automatically in any available content database. To prevent any other sites to be created on the particular content database, We can set maximum number of site collection on particular content database. read full article for details.