Create and associate a content database to a specified Web application and website set

Creating and associating a content database to a specified Web application and website set a Web application is not limited to using a single content database. SharePoint allows you to associate multiple Content databases to Web applications. One of the reasons is based on the size of the content database. If it is larger than 200 GB, it makes sense to divide it into two content databases. Another consideration is the data type in the content database. If a marketing website contains images and videos, it is reasonable to create a content database for this website set of data. Another example is to create a content database for the legal department to store all legal data. The last benefit is disaster recovery. Knowing where your data is and what the structure is will make your disaster recovery policies more efficient, useful, and flexible. This article teaches you how to create multiple Content databases to one Web application and apply suitable website collections to the corresponding content database. Preparation: Make sure that you are the field administrator and have the correct permission to create a database. Start: 1. Open the Management Center. Under application management, in the database section, click manage content database. 2. Click Add content database link.
3. The database name is suffixed with GUID by default. Modify the database name WSS_Content_Marketing. Other default values. Note that the name must comply with the naming rules. 4. To ensure that the website set is added to the appropriate content database, make sure that you are still managing the content database page. 5. Click the content database of the website set you do not want to add. 6. Set the status to offline in the database information area. Click OK.
7. Navigate to Application Management and click website set. Click Create website set. 8. Enter the title and URL, select the template, and set the first website administrator. Click OK. 9. The website set should be created and added to the appropriate content database. To check, navigation manages the content database. You can see the stopped and enabled content database.
For more information, sometimes you do not want to add more website sets to the content database. You can: 1. Choose Management Center> database> Manage content database. 2. Click the database that you do not want to add the website set. 3. Change the database capacity settings. The maximum number of websites allowed to be created for this database is the current number of website sets. 4. Change the number of the largest website book created before the warning is generated to be smaller than the number of the current website set.