Backup Utility

[Former Member]

Is there a backup utility we can use that will stop the services, backup the db, then restart the services? Maybe someone has put together a bactch file or something to run as a scheduled task? We need to backup BOE database each night automatically. Any help will be greatly appreciated.

[Former Member · Accepted solution]

Hey Brent,

No offense, but there are 465 answers to the question you're asking in the forum, so my question would be: none that can answer yours?

http://www.sdn.sap.com/irj/scn/advancedsearch?query=backup+bo

With all due respect, please review the first post-it: Search before asking.

Regards

Romain

[Former Member · Accepted solution]

I found none that could answer my question. If I missed it, please point me to it.

Thanks

[Former Member · Accepted solution]

Sure, would you clarify which DB, which OS and which product?

Concept in general is quite simple:

- stop BOE (SIA on XI3, All services, finishing with CMS on XIr2, ideally putting a sleep between all servers shutdown and CMS shutdown). NET STOP on windows.

- Backup the CMS DB (imp/exp on Oracle, mysqldump for MySQL)

- Backup the FileStore (use robocopy in a batch for delta backup)

- Restart BOE

The "catches" are around Oracle doing export in US7ASCII by default under Unix, which is a destructive conversion from UTF8 (your CMS DB should be under this format as per supported platforms), so you need to make sure to set the NLS_LANG to UTF8 on Unix user doing the backup.

Other than that, batch as shell can do all of that.

Regarding the "general" best practices, I recommend the following doc:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c0020482-ca8d-2c10-9bad-d1bd332bbb28

Note on integrated BO tools: Import Wizard as biarengine are good tools for promoting a set of data between wto BOE environment or if you need to backup a specific set, but they are definitly not recommended as backup solution. I would refrain from this solution IF the point of the backup is to be able to recover the system when it crashes.

Does that answer the question?

[Former Member · Accepted solution]

Thanks.