Thursday, 3 November 2016

How to add content databases in SharePoint 2016

We can add a content database to a SharePoint 2016 farm by using the SharePoint Central Administration website. We can login to SP central Admin page and we can create with GUI mode.
We can add a new content database or attach an existing content database from a backup file.
Note: Before we begin this operation, review the following information about prerequisites:
  • The user account that is performing this operation must be a member of the Farm Administrators SharePoint group.
  • If you use Windows authentication to connect to SQL Server, the user account must be a member of the dB creator fixed server role on the SQL Server instance where the database is to be created.
So now we will show you how to create Content DB step by step with screen shots:
  • On the Start screen, click SharePoint 2016 Central Administration.

  • Click SharePoint 2016 Central Administer the SharePoint Central Administration website, click Application Management.
  • In the Databases section, click Manage content databases. On the Manage Content Databases page, click Add a content database.
  • On the Add Content Database page:
Specify a web application for the new database, Specify a database server to host the new database, Specify the authentication method that the new database will use and supply an account name and password, if they are necessary.
Note: The account name and password must already exist as a SQL Server login.
Specify the name of the failover database server, if one exists.
Specify the number of top-level sites that can be created before a warning is issued. By default, this is 2,000.
Specify the total number of top-level sites that can be created in the database. By default, this is 5,000.

  • Once click on ok, It will take some time to create content DB.
  • We can verify from CA page and from SQL server as well also we have command to verify Content DB.
We can get content db with command as well below is the same:
Get-SPContentDatabase -webapplication http://sp2016:2017


No comments:

Post a Comment