Export (0) Print
Expand All
0 out of 2 rated this helpful - Rate this topic

Add content databases in SharePoint 2013

Published: July 16, 2012

Summary: Learn how to add a content database to your SharePoint 2013 farm.

Applies to:  SharePoint Foundation 2013 | SharePoint Server 2013 

You can add a content database to a SharePoint 2013 farm by using the SharePoint Central Administration website or Windows PowerShell. The tool that you use depends on the kind of environment that you have deployed, your schedule requirements, and service level agreements that you have made with your organization.

In this article:

Before you begin

You can add a new content database or attach an existing content database from a backup file.

Before you 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 dbcreator fixed server role on the SQL Server instance where the database is to be created.

note Note:

Because SharePoint 2013 runs as websites in Internet Information Services (IIS), administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Adding a content database to a SharePoint 2013 web application

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.

    • For Windows Server 2008 R2:

      • Click Start, click Microsoft SharePoint 2013 Products, and then click SharePoint 2013 Central Administration.

    • 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.

    For more information about how to interact with Windows Server 2012, see Common Management Tasks and Navigation in Windows Server 2012.

  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 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 PowerShell

  1. Verify that you have the following memberships:

    • securityadmin fixed server role on the SQL Server instance.

    • db_owner fixed database role on all databases that are to be updated.

    • 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 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:

    • <ContentDbName> is the name of the content database to create.

    • <WebApplicationName> is the name of the web application to which the new database is attached.

For more information, see New-SPContentDatabase.

note Note:

To attach an existing content database to a web application, use the Windows PowerShell cmdlet Mount-SPContentDatabase. For more information, see Mount-SPContentDatabase.

note Note:

We recommend that you use Windows PowerShell when performing command-line administrative tasks. The Stsadm command-line tool has been deprecated, but is included to support compatibility with previous product versions.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.