Skip to Content

Disaster Recovery (DR) test in BusinessObjects

Pre requirement

  1. Take CMS database back up
  2. Check DR FRS path with same service account and check that account should have read and write access for that path.
  3. If it is possible then pauses all recurring reports which is on prod server otherwise it will get trigger as soon as you will start DR server, some of the will get fail coz FRS is different

Suppose we have 3 servers A, B, C. server A & B is production server and both server are in cluster. Server C is DR server.


  1. Go to Server A and stop all notification services like HAWK Agent.
  2. Go to CCM and stop SIA and Tomcat server
  3. logon to the server B and stop all notification services
  4. Go to CCM and stop SIA and Tomcat server.
  5. Now copy your FRS directory to DR FRS directory
  6. Failover your CMS database
  7. Take Database back up.
  8. Flip CNAME of DB instance from primary to DR
  9. Flip CNAME of managed application server host
  10. Now login to your DR server (server C)
  11. Start your notification services
  12. Go to CCM and create new SIA on CMS database
  13. Go to SIA properties to system account, use your service account which is same as your prod account.
  14. Start Tomcat and SIA
  15. Check the new FRS path is accessible with your service account and you have read and write access to that path.
  16. Now go to IFR server and Stop IFR server
  17. go to properties of IFR server and change Temporary Directory: and File Store Directory:
  18. Go to OFR server and Stop OFR server
  19. Go to properties of OFR server and change Temporary Directory: and File Store Directory:
  20. Start both the servers i.e. IFR & OFR server
  21. Now DR is fully activated.


  1. Run test report
  2. Communicate that testing has been completed and request failback procedures are invoked.

Note:- Don�t check reports based on Events coz it will not work or you need to change event server properties for events.


  1. Go to server C which is your DR server
  2. Stop notification services
  3. Stop SIA and tomcat
  4. Go to SIA properties change start up time to manual
  5. Go to SIA start up tab
  6. Select Local CMS server go to properties check auto start check box click on ok (after windows server restart, DR SIA will not come up and under cluster name.)
  7. Flip CNAME of database instance from DR to primary
  8. Flip CNAME of Managed application server host
  9. DBA to confirm data server is up and running and against appropriate back-end host.
  10. Now go to server A
  11. Start your SIA and then tomcat
  12. Start notification services on server A
  13. Follow the same steps for server B (step 7 to 9)
  14. Test some sample reports


Atul Divekar

You must be Logged on to comment or reply to a post.