SAP BI 4.x System Copy

Backup and restore of filestore and CMS database of a BusinessObjects Enterprise BI 4.1 system (System Copy)

Resolution

Taking a backup on the Production machine

1. From the Central Configuration Manager (CCM), stop the SIA
2. Take a backup of the CMS database.
3. Take a copy of the entire FileStore Input and Output folders (by default, under BOXI server installation folder)
4. Restart the SIA

Note: On BI4.X you must know the cluster key at the time the backup was taken to be able to connect a CMS to the restored database.

Restoring the backup to the Test machine

5. From the CCM, stop the SIA
6. Rename the existing FileStore folder (e.g.: FileStore_Old)
7. Copy the FileStore backup taken in step 3 into the BOXI server Test installation
8. Restore the CMS database.
9. Delete references to the original server as follows

WARNING: In this particular instance, the following command deletes the reference of the Business Objects Servers (parentid 16) in the database, as the production nodes/SIA (parentid 59) to avoid a system mixture. This should only be applied in a disaster recovery environment where the SIA and servers of production should not appear.

In the disaster recovery database, a delete command will remove the necessary references to the production

BOE XI 3.x	delete from cms_infoobjects6 where parentid=16 or parentid=59;
BI 4.0/BI 4.1	delete from cms_infoobjects7 where parentid=16 or parentid=59;

10. From the CCM, select “Add Server Intelligent Agent” or “Add Node”

1. When details are requested, use the name and port number of the existing Test SIA (SIA port number is 6410 by default).
   • For XI 3.x, make sure to select “Create default servers on the new node” and “Recreate Server Intelligence Agent on the local host, if it already exists in the CMS system database”
   • For BI 4.x, make sure to select “Recreate node”
2. Assign a port to the CMS (by default 6400) and select the restored CMS database of point 7. Enabling Auditing is optional at this stage and can be configured later
3. On BI 4.0 it will now ask for the cluster key – this is required to decode information from the restored database content
4. DO NOT START THE SIA YET

11. 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.
12. Start the SIA