Contents
Start Central Administration. On the SharePoint Central Administration website, click Application Management. On the Application Management page, in the Databases section, click Manage content databases. On the Manage Content Databases page, click Add a content database.
How to attach a database to a web application?
To attach a content database to a web application, the SharePoint farm service account must have db_owner permission for the content database. If the database already exists, it must be the same version as the SharePoint Server 2016 farm or this operation will fail.
On the SharePoint Central Administration website, click Application Management. On the Application Management page, in the Databases section, click Manage content databases. Select the web application for which you want to detach a content database. Click the content database that you want to detach.
How to attach or detach a content database?
To attach a content database that is a different version than the farm, use the To attach or detach a content database by using Windows PowerShell procedure in the following section. You might want to attach or detach content databases for the following reasons.
Can a database be on the same server as SharePoint?
As is the case with front-end servers and application servers, the configuration for database servers affects how well SharePoint Server performs. Some databases have to be on the same server as other databases. Conversely, some databases cannot be on the same server as other databases.
These databases are installed when any SharePoint Server edition is deployed. The Configuration, Central Administration Content, and Content databases are the three databases that are automatically installed when you deploy SharePoint Server. The configuration database contains data about the following: