Applications Server
 

Upgrading and Configuring SharePoint 2010 : Configuring a content database

 
11/15/2011 4:16:15 PM
In SharePoint 2010, content databases are the heart of an organization's data. This is where all the site content information, such as documents, list data, and web part properties, is stored. By default, the content database is set up with parameters that may not be optimal to your organization.

Thankfully, these parameters can be changed and tweaked to fit your installation. It is important to note what can be changed and the ramifications of the change. In this recipe, you will be exposed to the parameters and the possible changes that can be made.

Getting ready

Ensure that you are a member of the Farm Administrators SharePoint group on the computer accessing the Central Administration site.

How to do it...

  1. 1. Open Central Administration. Under the Databases section, click Manage Content Databases. A listing of content databases will be shown in blue.

  2. 2. Click on the content database whose parameter you wish to change. The screen with the parameters to be changed will appear. The items that can be changed are:

    • Database Information

    • Failover Server

    • Database Capacity Settings

    • Search Server

    • Remove Content Database

    • Preferred Server for Timer Jobs

  3. 3. Make the appropriate changes and click OK.

How it works...

  • Database Information: This section gives information on the status of the database. The drop-down list allows the administrator to change the database state. When a content database is taken offline, it is not available and sites cannot be created within it. Refer to the next screenshot:


  • Failover Server: This is a new option within SharePoint 2010. Entering a server name into this box will not set up the failover server. It tells SharePoint what failover database server to utilize in the event one is needed. Refer to the following screenshot:


  • Database Capacity Settings: This section controls the number of site collections that will be created within the content database. There is a warning level, which must be at least one less than the maximum number of sites that can be created. Refer to the following screenshot:


  • Search Server: The content database will utilize a search server. Depending on your environment, there may be more than one server in this drop down.


  • Remove Content Database: This section allows the administrator to disassociate the content database from the web application. It does not delete the content database from the SQL Server. The data is still available and untouched. Any content in the site collections, contained in the content database, will no longer be accessible. Refer to the next screenshot:


  • Preferred Server for Timer Jobs: In SharePoint 2010, we can dedicate a server for timer jobs. This server would be indicated here for the content database. Refer to the following screenshot:

 
Others
 
- Upgrading and Configuring SharePoint 2010 : Creating and associating content databases to a specific web application and site collection
- Administering Active Directory Domain Services : Working with Active Directory Snap-ins (part 2) - Saving and Distributing a Custom Console
- Administering Active Directory Domain Services : Working with Active Directory Snap-ins (part 1)
- Microsoft Dynamic CRM 2011 : Canceling and Reopening a Service Request Case
- Microsoft Dynamic CRM 2011 : Resolving a Service Request Case
- Systems Management Server 2003 : Server Modifications After Installation
- Systems Management Server 2003 : Modifying the Installation
- Creating a SharePoint Form with InfoPath Designer : Create a Form Library from InfoPath & Design a SharePoint Form Using the SharePoint Form Library Template
- Creating a SharePoint Form with InfoPath Designer : Publish Your Form & Use Your Form in SharePoint
- Microsoft Dynamics AX 2009 : Code Access Security
- Microsoft Dynamics AX 2009 : Classes and Interfaces
- Determining Exchange Server 2007 Placement
- Understanding AD Design Concepts for Exchange Server 2007
- Configuration Manager 2007 Overview : What is New in ConfigMgr 2007
- Configuration Manager 2007 Overview : Key Concepts
- Active Directory Domain Services on Server Core (part 2)
- Active Directory Domain Services on Server Core (part 1)
- Microsoft Dynamics GP 2010 : Improving information returned with SmartList Search
- Microsoft Dynamics GP 2010 : Getting warnings with SmartList Alerts
- Upgrading and Configuring SharePoint 2010 : Visual upgrade
 
 
Most View
 
- Windows 8 : Settings and Customization - Settings
- Windows Phone 8 : XAML Overview - Visual Grammar
- Windows 7 : Programming Drivers for the Kernel Mode Driver Framework (part 3) - KMDF Driver Structure and Concepts - Object Context Area
- Windows Vista : Working with Files and Folders (part 4) - Zip It Up, Customize Drive and Folder Icons
- Windows 8 : Creating a Windows Network - Configuring a Peer-to-Peer Network (part 2) - Enabling and Disabling Sharing
- Microsoft PowerPoint 2010 : Customizing Themes (part 3) - Customizing Theme Effects, Working with Custom Themes
- Adobe Photoshop CS5 : Fixing Problems Caused by Your Camera’s Lens
- Adobe Flash Catalyst CS5 : Changing stroke and fill (part 2) - Change stroke color and weight, Add and modify gradient fills
- Getting Started with Microsoft Excel 2010 : Moving Around the Workbook
- Adobe Dreamweaver CS5 : Working with Web Page Tables - Changing Cell, Row, or Column Properties
 
 
Top 10
 
- Windows 8 for Business : Disk Encryption - EFS, BitLocker and BitLocker To Go
- Windows 8 for Business : Domain Join and Group Policy
- Microsoft Visio 2010 : Distributing Templates and Stencils (part 2) - Creating a Separate Stencil for Shape and Code Delivery
- Microsoft Visio 2010 : Distributing Templates and Stencils (part 1) - Creating a Template with a Document Stencil
- Microsoft Visio 2010 : Introducing Automation and VBA Code (part 3) - Calling VBA Code from a SmartShape
- Microsoft Visio 2010 : Introducing Automation and VBA Code (part 2) - Using the Macro Recorder to Generate Code
- Microsoft Visio 2010 : Introducing Automation and VBA Code (part 1) - Exploring the VBA Development
- Microsoft Access 2010 : Introduction to Relational Database Design (part 2) - Normalization and Normal Forms
- Microsoft Access 2010 : Introduction to Relational Database Design (part 1) - Rules of Relational Database Design
- Windows Phone 8 : Scheduled Notifications (part 3) - Reminder Registration, Reminder Sample