Database Maintenance for Microsoft® SharePoint® Products and Technologies

Summary:
This paper describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint Products and Technologies.

Link, http://go.microsoft.com/fwlink/?LinkId=111531&clcid=0x409

Abstract: 
This white paper provides information and guidelines for maintaining the databases that host Microsoft® SharePoint® Products and Technologies data and configurations. It describes and provides examples of the database maintenance tasks that we recommend when using SharePoint Products and Technologies.

Highlights:

  • Check for and repair consistency errors by using dbcc checkdb
  • Measure and Reduce Fragmentation
  • Fine tuning index performance by setting fill factor
  • Shrinking data files
  • Creating SQL Server 2005 Maintenance Plans