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

Comments (1)

  1. Buntu says:

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