Creating and associating a content database to a specified Web application and site collection A Web application is not limited to using a single content database. SharePoint allows you to associate multiple content databases to a Web application. One reason is based on the size of the content database. If it is larger than 200G, it makes sense to divide it into two content databases. Another consideration is the type of data in the content database. If a marketing site contains pictures and videos, it is reasonable to create a content database for this site collection data only. Another example is the creation of a content database for the legal department to hold all legal data. Finally, there is the benefit of disaster recovery. Knowing where your data is and what the structure is, it will be more efficient, useful, and flexible to apply your disaster recovery strategy. This article teaches you to create multiple content databases into a Web application and apply the appropriate site collection to the corresponding content database. Prepare: Make sure you are a farm administrator and must have the correct permissions to create the database. Start: 1. Open Central Administration, under Application management, in the Database section, click Manage Content databases. 2. Click the Add content Database link.
3. The database name defaults with a GUID suffix. Modify the database name wss_content_marketing. The rest defaults. Note that naming conforms to the naming convention. 4. To ensure that the site collection is added to the appropriate content database, ensure that you are still managing the content Database page. 5. Click the content database that you do not want to add to the site collection. 6. Set the status to offline at the database information point. Click OK.
7. Navigate to Application management and click Site collection. Click Create Site collection. 8. Fill in the title, URL, select the template, and the first site collection administrator. Click OK. 9. The site collection should be created and added to the appropriate content database. In order to check, the navigation manages the content database. You can see the stopped and enabled content databases.
More information Sometimes you don't want to add more site collections to your content database, you can: 1. Manage the content database in central Administration-database. 2. Click the database you want to add the site collection to. 3. Change the database capacity setting, the maximum number of sites that this database allows to create is the number of current site collections. 4. Change the maximum number of Web site books created before generating a warning to a number that is less than the current site collection.
