Export (0) Print
Expand All

Database management for SharePoint 2013 learning roadmap

SharePoint 2013
 

Applies to: SharePoint Server 2013, SharePoint Foundation 2013

Topic Last Modified: 2013-12-18

Summary:Use this learning roadmap to build expertise about database management in SharePoint 2013.

SharePoint 2013 makes it easy for people to work together. SharePoint 2013 enables you and your employees to set up web sites to share information with others, manage documents from start to finish, and publish reports to help everyone make informed decisions. Database management in SharePoint 2013 depends on SQL Server. The capacity and feature requirements of your SharePoint environment determine the edition of SQL Server that you run and the size of the databases.

The following actions apply to management of SharePoint 2013 databases:

  • Create

  • Upgrade

  • Move and rename

  • Back up and restore

If you are new to database management, information in this article can help you learn about database management and the features that are available. Prerequisite articles explain the fundamentals of database management. You must understand the prerequisite information first. Subsequent articles assume that you understand the fundamentals. After you understand the basics, you can read articles in the Level 100, 200, and 300 sections.

Learning Roadmap Banner

We recommend that you read the articles in the order listed.

This section contains links to many articles and books that contain background information that will help you fully understand how database management works.

  • Step 1: Learn about the databases that support SharePoint 2013.

    SharePoint 2013 is an application that is built on the SQL Server database engine. Most SharePoint content and settings are stored in SQL Server in relational databases. The SharePoint 2013 system databases include the Configuration, Content, and Central Administration Content databases.

    SharePoint 2013 uses the following types of databases:

    • Configuration

    • Content

    • Service application

    See the Databases that support SharePoint 2013 model. For comprehensive details about all SharePoint 2013 databases, see Database types and descriptions (SharePoint 2013).

    Your goal is to understand the different types of databases that support SharePoint 2013 and their requirements. It is important to understand database sizes and locations, plus any requirements that the database has so you can optimize the performance in a SharePoint 2013 farm.

  • Step 2: Learn about SQL Server in a SharePoint 2013 environment.

    SQL Server is a required part of SharePoint 2013 because it stores all of the relational databases. SharePoint 2013 supports SQL Server 2008 R2 with Service Pack 1 (SP1) and SQL Server 2012. See Overview of SQL Server in a SharePoint environment (SharePoint 2013). For configuration steps, see Best practices for SQL Server in a SharePoint Server farm.

    Your goal is to understand how to interact with SharePoint 2013 databases that are stored in SQL Server. Also learn how to use SQL Server to plan and maintain databases in your SharePoint 2013 farm.

The following articles contain introductory information about database management in SharePoint 2013.

  • Step 1: Learn about database management in the SharePoint 2013 upgrade process.

    See Overview of the upgrade process to SharePoint 2013.

    Your goal is to learn about the three SharePoint 2013 upgrade stages that involve databases. Stages two, three, and four include; copy databases to the new farm, upgrade the service applications, and then upgrade the content databases.

  • Step 2: Learn about backup and recovery in SharePoint 2013.

    See Overview of backup and recovery in SharePoint 2013.

    Your goal is to learn about the backup and restore processes that are available for SharePoint 2013. It is important to have a backup and recovery plan before you deploy SharePoint 2013 to protect your data. An effective backup and recovery strategy is a required process to make sure that your data is available. At any point in time, you may have to restore your SharePoint databases, sites, site collections, document libraries, and digital content. While this is considered disaster recovery, it is an absolute requirement as you manage the databases that contain the SharePoint 2013 data.

  • Step 3: Learn about how to use Remote BLOB Storage (RBS) in a SharePoint 2013 farm.

    See Overview of RBS in SharePoint 2013.

    Your goal is to learn how and when to use Remote BLOB Storage (RBS) in a SharePoint 2013 farm.

The following articles contain intermediate information about database management as it relates to backup and restore solutions in SharePoint 2013.

  • Step 1: Learn about how to prepare to back up and restore a SharePoint 2013 farm.

    See Prepare to back up and restore farms in SharePoint 2013.

    Your goal is to learn about requirements and restrictions for backup and recovery in SharePoint 2013. Besides natural disasters and system failures, there are business reasons why you should back up your SharePoint 2013 farm.

  • Step 2: Learn about SharePoint 2013 backup solutions and how to restore them.

    See Backup solutions in SharePoint 2013 and Restore (SharePoint 2013).

    Your goal is to understand how to implement the backup solutions and then restore these in SharePoint 2013. The backup and restore solutions and procedures include SharePoint system databases, service applications, farms, farm configurations, web applications, site collections, and apps for SharePoint. Basically anything that you can back up in SharePoint 2013, you can also restore.

  • Step 3: Learn about best practices for backup and restore and for SQL Server in a SharePoint 2013 farm.

    See Backup and restore best practices in SharePoint 2013 and Best practices for SQL Server in a SharePoint Server farm.

    Your goal is to become familiar with Microsoft recommendations for backup and restore procedures. Also, learn the recommended processes to deploy SQL Server in a SharePoint 2013 farm. Both of these areas are important aspects to deploy and maintain SharePoint 2013.

The following articles contain advanced information about database management in SharePoint.

Your feedback is valuable and welcome! Please rate this content by using the Did you find this helpful section at the bottom of the article, or send your comments and suggestions to SharePoint IT Documentation Feedback (itspdocs@microsoft.com). The author will review your comments and use them to help improve this documentation. Your e-mail address won't be saved or used for any other purposes.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft