EPM Database Maintenance Tasks
After you deploy EPM 2007 in your production environment, I highly recommend you have a SQL maintenance plan in place.
Maintenance tasks that should be in this plan include:
- Backup
- Check DB integrity
- Rebuild Index (-> update statistics)
- History cleanup
- Maintenance cleanup
For more information on this subject please check the standard SQL documentation as well as these two articles for SharePoint databases (thank you Chris Gideon for the pointers):
- How to defragment Windows SharePoint Services 3.0 databases and SharePoint Server 2007 databases https://support.microsoft.com/default.aspx?scid=kb;en-us;943345&sd=rss&spid=11373
- Information about the Maintenance Plan Wizard in SQL Server 2005 and about tasks that administrators can perform against SharePoint databases https://support.microsoft.com/kb/932744