As a sharepoint administrator you must be facing regular tasks to Dismount Mount content database in sharepoint 2019 using powershell. This is most common and frequest task everyone faces. User requests to restore content database from sharepoint production environment for a particular date and time in UAT environement
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.