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



Thanks 

1 comment:


  1. My name is Leah Brown, I'm a happy woman today? I told myself that any loan lender that could change my life and that of my family after having been scammed separately by these online loan lenders, I will refer to anyone who is looking for loan for them. It gave me and my family happiness, although at first I had a hard time trusting him because of my experiences with past loan lenders, I needed a loan of $300,000.00 to start my life everywhere as single mother with 2 children, I met this honest and God fearing online loan lender Gain Credit Loan who helped me with a $300,000.00 loan, working with a loan company Good reputation. If you are in need of a loan and you are 100% sure of paying the loan please contact (gaincreditloan1@gmail.com)

    ReplyDelete