How do you backup Business Objects?

I had a technical question… I was wondering how to backup the web version of business objectives. I am new to this program so please explain in detail the process. Just in case, if you can’t backup the web version, is there anyother way to backup the files? Thank you in advance.


atripath (BOB member since 2009-06-02)

You don’t back up BO. You back up the database and the file system.

It’s pretty simple. You just need to back up your repository database and both you Input and Output FRS. It’s a good idea to do these at the same time so things stay synchronized.

The problem with all of this is that it’s is rare to have enough space to recover the information. But, that’s another story.


Steve Krandel :us: (BOB member since 2002-06-25)

Hello,

Just on this it’s a good idea to stop all the services before you do the database backup and file store copy so they are consistient.

In our environment we have a script that stops all the Business Objects services, backs up the database, copies the file store to another server and then starts all the business objects services again.

We’ve had to restore in the past based of those backups and have not had any issues.

Cheers,

Chris


ChrisRNZ :new_zealand: (BOB member since 2009-06-03)

If you do the traditional backup (backup of your CMS database and a file backup of your Input/Output filestore), be aware that a restore will be a full restore (overwriting all BusinessObjects content), no partial restore is possible at this time
If you need only a partial restore you will need a separate server (you could use a virtual server for this of course) to do a full restore. From that server you then run the import/export wizard (see the manuals) to move selected content (universes, documents, etc.) to your production server.
The restore process can be time consuming (a few hours).

Note:
Should you have done any customization of Infoview, etc. you will need to backup these changes (*.jsp files, etc. on Tomcat, etc.) as well.

You should definately do such a backup as part of your backup and recovery plans.

Additionally:
In addition to the full backup consider using BIAR files (look in the manuals, keyword: import/export wizard). With BIAR files you will be able to do a a partial restore of any content very quickly.
Be aware that BIAR files should always be double checked, as they used to be a “little bit buggy” (especially if the BIAR file becomes larger in size).

Guessing that you have not received any formal training I strongly suggest attending an official SAP trainning class (administering BusinessObjects Enterprise).


Andreas :de: (BOB member since 2002-06-20)

I’ve got in the habit of taking a daily snapshot of universes and reports into a BIAR file. Just my personal backup, in addition to the filesystem and DB backups :slight_smile:


cashworth (BOB member since 2005-02-09)

thats a very good suggestion , am sure it will be everyones habit soon
really helpful


amruta (BOB member since 2007-04-24)

Thanks for the help. I understand how to backup the CMS server, but I am still confused on how to exactly backup the Input and Output repository servers. Are those servers backedup using the Import Wizard, or is there another way to back them up?


atripath (BOB member since 2009-06-02)

The Input/Output FRS write files to the location specified for those server services, so you need to do a regular file backup (in addition to the database backup for the CMS database). You do not backup the individual server services, you do backup the BOE repository, which as of XI R2/R3 consists of two parts: the CMS database and the Input/Output FRS files.

Remember, CMS database and Input/Output FRS files go hand in hand.

As I mentioned, for a complete backup there is more to consider:

  • The bootstrap file (for the SIA in XI R3.x)
  • Any customized code/infoview/jsp pages
    etc.

I can only strongly recommend attending an official SAP training class (Administering BOE).

[Rant ON]
I am suprised, that companies dash out 100Ks $$ for software, but get cheap on either hiring experienced consultants or sending their staff to training for a couple of 1000s $.
[/Rant OFF]


Andreas :de: (BOB member since 2002-06-20)

Hi ChrisRNZ,

I have the same requirement. Could you share backup & restore script?


jayad (BOB member since 2008-07-11)

To backup your CMS database, you might want to check with your DBA and to backup the filestore, you might want to check with your Netwrok admins. Hope that helps.


zack :us: (BOB member since 2007-08-02)

Is there a way to “schedule” the ImportExport Wizard with the right options to run automatically?
Thanks
Bill


cscbharvey (BOB member since 2009-04-07)

Out of the box, no. You can’t schedule the Import Wizard to create a biar file. You might be able to do it via SDK or some custom code, I am guessing.

Mitra


Mitra Moini (BOB member since 2002-09-01)

  1. Scheduled FileSystem Backup of the entire business objects folder
  2. Scheduled DB Backup hosting the metadata
  3. Manual BIAR backup once a week

is how our backup mechanism of BO is.


whizkid420 (BOB member since 2003-03-26)

Err… I am struggling to do it, theoritically it is possible.
It is explained quickly in the BO admin guide , section “BIAR command line tool”, page 419.

You will have to create a script that calls a java stuff. And create a query that fetch the objects you want to backup (reports, folders, etc…).

For my 200+ reports it takes 30mn and creates a 400Mb file.

Samuel.


popa_chubby :es: (BOB member since 2009-07-14)

@popa_chubby, can you please share the script you are using to take the backup of reports and users. I have the same requirement here.


mark777999 (BOB member since 2010-05-12)

While creating a backup from the Input FRS and CMS database can this easily be transfered to a different machine or is the name somewhere hardcoded?.

We would like to have some kind of a remote failover system. As this machine would have a different name I would presume this could cause some issues as I know that Crystal is rather picky on changing server names.

Regards,


fenix4life (BOB member since 2009-02-04)

then, you should use and manage logical name for servers and use it when installing bo xi :


bernard timbal :fr: (BOB member since 2003-05-26)

Hello

I guess, he must create a BIAR Files then exporting it’s to other servers?

Thank you veru much


zouwebi (BOB member since 2007-06-18)

Pardon my ignorance, but where do I find the bootstrap file for the SIA??

The rest is good and I have that part under control - just that last piece (since there is no customization here).

Thanks!!!


Charles Killam :us: (BOB member since 2003-04-24)

In Windows:

E:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86


clarence (BOB member since 2005-11-18)