EPM Database Maintenance Tasks

Christophe Fiessinger's Blog

The latest news you need to know about Microsoft Enterprise Social & Project Portfolio Management

EPM Database Maintenance Tasks

Rate This
  • Comments 4

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):

Leave a Comment
  • Please add 6 and 7 and type the answer here:
  • Post
Page 1 of 1 (4 items)