Whitepaper on Database Maintenance for SharePoint is now live!

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

1 Comment


  1. What guidelines do we have for SharePoint 2013 databases? Are they the same?

    Reply

Leave a Reply to Buntu Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.