cancel
Showing results for 
Search instead for 
Did you mean: 

Crystal Reports Server XI - what files need to be backed up?

Former Member
0 Kudos

I don't want to set up a fail over cluster which there seems to be plenty of information on.

All I want to do is identify what files I need to backup incase I need to do a restore.

We use Tivoli Storage Manageru2019s backup and recovery solution for backups

Any help would be appreciated...

Accepted Solutions (0)

Answers (2)

Answers (2)

BasicTek
Active Contributor
0 Kudos

let us know if [this white paper is helpful|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c09a069c-6a3f-2b10-3399-e0ed04d866f8]

Regards,

Tim

0 Kudos

Depends on the complexity of your deployment. Basically, your CMS DB and the FileStore directory are the only objects outside of the application itself that need to be backed up. The CMS DB contains all your security and links to reports, while the FileStore contains all the reports and instances themselves. You want to have the backups of these synchronized, so that you limit the number of report links that point to nothing, or have reports in your FileStore that have no links to them.

Other than that, if you have made modifications to your deployment to allow for LDAP/AD authentication, modification to server properties to adjust timeouts or orther parameters, etc you should have these documented so that they can be reaccomplished.

If you have the CMS DB and the FileStore, you can reinstall, point to the CMS DB, point to the FileStore, and be back up and running.

Those Tivoli backups should not be run on the entire installation volume while the system is up and processing scheduled reports. You will see the backup program report errors, as temp files are being created/destroyed, and executables will be locked. It may still run successfully with errors, but it may also cause issues with the report processing and stability of your system. Depends on how busy it is - it could still run successfully if it's quiet. Recommended best practice is to stop services, backup, start services.

Former Member
0 Kudos

Thanks very much for the information provided.

I can locate the file store records at:

C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\FileStore

Where is the CMS DB located on the system?

Thanks

Sinead

Former Member
0 Kudos

Where is the CMS DB located on the system?

Former Member
0 Kudos

You may be able to find this from ODBC administrator. The CR installation would have created a datasource with name like "Business Objects CMS" or something similar. You can also get the database name from CCM in the server. check the properties for CMS.

Former Member
0 Kudos

Thanks for all the information provided

Backups now set up

Cheers