Database Maintenance for Microsoft® SharePoint® Products and Technologies
This paper describes the recommended maintenance strategies for the databases that host content and configuration settings for SharePoint Products and Technologies.
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.
- 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