Managing SharePoint 2010 Databases and Content Storage

SP-IN-DB-301-EN (3 Days Course)

 

 

Download PDF version

 

Introduction

SharePoint deployment is made possible via the storage capabilities afforded to it by the Microsoft data platform. Within the SharePoint 2010 framework architecture there are several SQL Server databases that need to be administered, as well as the rest of the application and business process framework. A means of storage is required for metadata, search data and also user data. In this seminar, we will explore each of the databases that facilitate this storage. It is not always the case that the storage will be facilitated within a local database. To this end we will look at additional storage and access features such as the Remote Blob Storage (RBS) and how the SharePoint platform exploits the FILESTREAM SQL Server data type provider to externalize these BLOBs. In addition we will cover best practices for the creation, maintenance, optimization and hardening of the data platform.

Target Audience

  • SharePoint Architects
  • SharePoint Administrators
  • SQL Server DBAs

Course Summary Outline

Day 1:

Module 1: An introduction to the SharePoint  databases

  • The types of database found in SharePoint  2010 
  1. Content databases
  2. Metadata databases
  3. Search databases
  • Additional considerations when implementing on SQL Server 2008 R2

Module 2 : Understanding and Implementing Content Databases

  • How SharePoint stores content
  • Creating Content Databases
  1. Pre-Creating the Content databases and why this is beneficial
  • HOL 2.1 Pre-creating the Content Databases 

Day 2:

Module 3: Maintaining the Content Databases

  • Setting the databases to Read-Only mode
  • Moving content databases
  • Moving site collections between databases
  • HOL 3.1 Attaching an existing content database within a SharePoint 2010 site
  • HOL 2.2: Creating Sites in multiple Content Databases
  • Securing SharePoint databases 

Module 4: High Availability

  • Backup and Restore techniques
  • HOL 3.1: Using various techniques to backup and restore the databases
  • HOL 3.2: Recovering a lost SharePoint database 

Day 3:

  • Database Mirroring
  • Hot Standby Farm
  • HOL 3.2 Setting up database Mirroring for a content Database

Module 5: Performance Tuning Content Databases 

  • Performance Tuning Considerations
  • Content Databases Best Practices

Module 6: Remote Blob Storage

  • An introduction to the process of storing Binary Large Objects (BLOB’s) Remotely
  • An investigation of BLOB externalization using the RBS FILESTREAM Provider
  • HOL 4.1: Configuring BLOB externalization using the RBS FILESTREAM provider 
Login