Automatic or scripted backup of appset (application set)

[Former Member]

Hi experts,

I'm currently using BPC 7.5 MS and I try to schedule an automatic backup in the same way I can manually backup an appset with server manager.

Unfortunately, I don't find any script or method allowing to doing this task.

Is there a way to script the backup task?

Regards,

Guillaume

[former_member186498]

Hi Guillame,

please see http://wiki.sdn.sap.com/wiki/display/CPM/BestPracticesforBackuponBPCfor+Microsoft

[1455212 - Best practices for BPC MS backup|http://service.sap.com/sap/support/notes/1455212]

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/20a26f50-4252-2a10-8c97-a2c7058cd...

Kind regards

Roberto

Edited by: Roberto Vidotti on Feb 16, 2012 4:11 PM

[Former Member]

Many thanks Roberto !

I found a useful "how to" in your links explaining how to create the script part.

Too bad SAP doesn't develop a package doing this backup...

Regards,

Guillaume

[former_member376583]

Hi Guillaume,

I just created a WIKI page : http://wiki.sdn.sap.com/wiki/display/CPM/How+to+automate+backups+on+BPC+for+Microsoft

That explains and provide somes scripts to automate BPC Backup through simple Windows scheduled tasks.

Hope this will be helpful

PS :The procedure has been written for BPC 10 but it's not much different for BPC 7.5.

Let me know if you are further questions.

Kind regards,

Samuel

[Former Member]

Hello Guillaume,

There is no built-in BPC script/task to backup AppSets the way Server Manager does.

However, you can create an SSIS package to perform a similar backup. All you need to do is:

- backup SQL Server database

- backup SSAS database

- backup AppSet folder in FileDB

- backup AppSet folder in Webfolders

You can Zip folders as well. Beneficially, you can use SQL Server backup compression. And to make it work similar to Server Manager backup, you can stop "OutlookSoft SendGovernor Service" prior to backups and start it after completion.

Hope that helps,

Akim

P.S. on another hand, you might want to have a separate SQL Server database backup with transaction logs to improve recoverability. So, I'd just go with separate backups for SQL Server DBs, SSAS DBs and folders.

Edited by: Akim Zubarchuk on Feb 16, 2012 10:06 AM

[Former Member]

Thank you very much for your Answer Akim.

Unfortunately I'm not an expert with SSIS. Is there a way to find a dtsx model somewhere?

If not, I will ask for help to a DBA.

Regards,

Guillaume