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:
Deploy cumulative updates (Project Server 2007) for more information on how to deploy cumulative updates (Office Project Server 2007)
Deploy software updates for Office SharePoint Server 2007 for more information on how to deploy cumulative updates
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: