BI 4.1 Disaster Recovery in Windows Platform

Disaster Recovery for SAP Business Objects 4.1/SAP Crystal Enterprise 2013
Prerequisites:
1. File Store Input and Output folders
2. Back up of CMS Database
3. Cluster Key Information.

Restoring/Recovery steps:
1. From the CCM, stop the SIA
2. Rename the existing FileStore folder
3. Copy the file store folder to the server which we are restoring.
4. Delete references to the original server as follows.
Select * from cms_infoobjects7 where parentid=16 or parentid=59;
delete from cms_infoobjects7 where parentid=16 or parentid=59;
Business Objects Servers (parentid 16) in the database, as the production nodes/SIA (parentid 59)
5. From the CCM, select "Add Server Intelligent Agent" or "Add Node"
6. Add node with default servers.
7. Assign a port to the CMS (by default 6400) and select the restored CMS database. Enabling Auditing is optional at this stage and can be configured later
8. On BI 4.0 it will now ask for the cluster key - this is required to decode information from the restored database content
9. DO NOT START THE SIA YET
10. When the SIA is created, go to SIA > Properties > Configuration and modify the ClusterName of the restored environment to be different from the production environment
11. Start the SIA