Need Help On Setting Up Disaster Recovery For Crystal Reports BOE 3.1

[Former Member]

Version Of Crystal Report: BOE 3.1 ( Product: 12.1.0)

Operating System : Windows

Objective: Create a Disaster Recovery System for Crystal Reports

Steps Taken :

1) Installed Same version of Crystal reports on the DR server

2) Copied the File store from the production server to the Dr server

3) From the production MYSQL database exported the BOE12 database using MYSQLDUMP

4) Imported the DUMP file form production to the DR MYSQL database.

Issues:

The DR Crystal application comes up fine. The issue is it is internally using the production set-up because it is pointing to the production server host name settings.

Also The production setup is installed on C: drive and Dr setup is installed on D Drive. So the file store's are in different locations. Need help in re configuring them also.

We need help with changing this configuration from production to DR.

[DellSC]

There are a couple of ways of handling DR systems.

- A company I used to work for had a complete environment - with the same server names - at a separate location.  This is the only configuration that I know of where you can do an exact copy of the CMS database and get it to work.

- If the DR system is on a server with a different name, I usually recommend the following to my clients:

     1.  Install the system with its own database and configure as appropriate.

     2.  Use the BIAR Command Line Tool to back-up the production system on a regular basis.  Depending on the number of reports and users, you may need to run this multiple times using a different parameter file each time so that you can limit the number of reports that are in each .biar file so that there is less risk of corruption.  For more information about how to use this, see chapter 16 of the BOE 3.1 Admin Guide.  You will NOT want to include everything, just reports, universes, connections, folders, users, security, etc.

     3.  Import the .biar file(s) from step 2 in to the new system.

-Dell

[Former Member]

Thanks Venkat,Dell,

I have tried the steps that are given in the link by Manikandan .E. However my SIA was not pointing to the backup that I restored. So I started an export of the BIAR file from the production to the DR system.

I will keep you posted with the updates.

Regards,

Haresh

[Former Member]

Hi Haresh,

What is the issue your are facing when you perform Disaster Recovery?

Below document may help you.

[Former Member]

Hi,

Please see this blog: