Disaster recovery for Planning Server computers
Updated: 2009-04-30
This chapter describes Planning Server system database disaster recovery scenarios and what to do when a Planning Server database fails.
Note
The terms Windows SharePoint Services and SharePoint Services are used collectively in PerformancePoint Server documentation to refer to Office SharePoint Server 2007 and Windows SharePoint Services 3.0.
Background
There is only one system database for the whole Planning Server system. The Planning System Database contains PerformancePoint Planning application information and Planning security information. Although each application database also contains security data that relates to that application, the system database contains the master copy of the security data. All Planning applications might share some security data in the system database.
There is only one service database for the whole Planning Server system. The Planning Service Database contains Planning Process Service processing logging and auditing job information. Planning Process Service also processes the workflow job data in each individual application database. All applications feed their logging and auditing requests into the one service database. However, Planning Process Service does not depend on the service database alone. It processes requests in both the service database (logging and auditing) and the application database (workflow jobs request).
If the OLAP database fails, an OLAP database can always be regenerated. Each model site inside each application can have its own OLAP database and each can be on a different OLAP database server. An application or model site has only one OLAP database.
Note
The scenarios discussed in this chapter are only for the disaster recovery cases in which you recover an older backup version to the same location. If you need to recover an older backup version to a different location, follow the procedure outline in Mirroring the Planning Server.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for PerformancePoint Planning Server.