Share via


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

This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.

 

Topic Last Modified: 2016-11-14

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: