Adding a content DB in SharePoint
2013
You can add a content database to
a SharePoint 2013 farm by using the SharePoint Central Administration website
or Windows Power Shell
You can use
the procedures that are described in this article to create a new content
database and attach it to a web application. If you are using Windows
authentication to connect to SQL Server, the user account must also be a member
the SQL Server dbcreator fixed server role on the SQL Server instance
where the database will be created. If you are using SQL authentication to
connect to SQL Server, the SQL authentication account that you specify when you
create the content database must have dbcreator permission on the SQL
Server instance where the database will be created.
To add a content database to a web application by
using Central Administration
1.
Verify that
the user account that is performing this operation is a member of the Farm
Administrators SharePoint group.
2.
Start
SharePoint 2013 Central Administration.
o For Windows Server 2008 R2:
§ Click Start, click Microsoft
SharePoint 2013 Products, and then click SharePoint 2013 Central
Administration.
o For Windows Server 2012:
§ On the Start screen, click SharePoint
2013 Central Administration.
If SharePoint 2013 Central Administration is not on the Start
screen:
§ Right-click Computer, click All
apps, and then click SharePoint 2013 Central Administration.
3.
On the
SharePoint Central Administration website, click Application Management.
4.
In the Databases
section, click Manage content databases.
5.
On the Manage
Content Databases page, click Add a content database.
6.
On the Add
Content Database page:
1. Specify a web application for the
new database.
2. Specify a database server to host
the new database.
3. Specify the authentication method
that the new database will use and supply an account name and password, if they
are necessary.
 Important:
|
|
The
account name and password must already exist as a SQL Server login.
|
4. Specify the name of the failover
database server, if one exists.
5. Specify the number of top-level
sites that can be created before a warning is issued. By default, this is
2,000.
6. Specify the total number of
top-level sites that can be created in the database. By default, this is 5,000.
7.
Click OK.
To add a content database to a web application by
using Windows Power Shell
1.
Verify that
you have the following memberships:
o securityadmin fixed server role on the SQL Server
instance.
o db_owner fixed database role on all
databases that are to be updated.
o Administrators group on the server
on which you are running the Windows PowerShell cmdlets.
An administrator can use the Add-SPShellAdmin cmdlet to grant
permissions to use SharePoint 2013 Products cmdlets.
Note:
|
If you do
not have permissions, contact your Setup administrator or SQL Server
administrator to request permissions. For additional information about
Windows PowerShell permissions, see Add-SPShellAdmin.
|
2.
On the Start
menu, click All Programs.
3.
Click Microsoft
SharePoint 2013 Products.
4.
Click SharePoint
2013 Management Shell.
5.
At the
Windows PowerShell command prompt, type the following command:
New-SPContentDatabase
-Name <ContentDbName> -WebApplication <WebApplicationName>
Where:
o <ContentDbName> is the name of
the content database to create.
o <WebApplicationName> is the
name of the web application to which the new database is attached.
I hope the above information will help you to resolve the issue, in case of any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues, Thank you.
