Operations and maintenance for an EPM-Microsoft Office SharePoint Server 2007 extranet environment

Actualizado: febrero de 2010

 

Última modificación del tema: 2010-02-24

This article describes operations and maintenance plans for an Enterprise Project Management (EPM)/ Microsoft Office SharePoint Server 2007 extranet environment.

For more information about how to plan and deployment, see Plan and deploy an EPM and SharePoint Server 2007 extranet environment.

Operations and maintenance

Office Project Server 2007 is a Windows SharePoint Services 3,0 application. Therefore, the recommendations for Windows SharePoint Services 3,0 and Microsoft Office SharePoint Server 2007 database maintenance apply to Office Project Server 2007 also. Among things, the database maintenance will include the following:

  • Checking database integrity

  • Defragmenting indexes by either reorganizing them or rebuilding them

  • Updating the table Statistics

For additional details review:

SQL Server 2005 Maintenance Plans (https://technet.microsoft.com/en-us/library/ms187658(SQL.90).aspx)

Database maintenance for Office SharePoint Server 2007 (white paper

For additional details review:

Backup & recovery and disaster recovery processes

The backup and restore procedures for the whole farm (existing or new configuration) are more complex for an EPM-focused Microsoft Office SharePoint Server 2007 farm. For an EPM-focused Microsoft Office SharePoint Server 2007 extranet farm, we have to think about backup & recovery procedures for many more components and content databases.

Office Project Server 2007 related data may probably require a different frequency of backup & recovery and data refresh compared to the rest of Microsoft Office SharePoint Server 2007 extranet applications sharing the same farm resources.

Make sure that your Backup & Restore and Disaster Recovery Processes cover all components and content databases for the whole EPM-focused Microsoft Office SharePoint Server 2007 extranet farm.

For additional details review: