Backup of Application Set in BPC 7.5 MS

[Former Member]

Hi All,

I would like to take a backup copy of an appset in BPC 7.5 MS version, I know this is possible in BPC 7.5 NW version.

But how can I do in MS Platform ?

Is there a document or step by step guide on this.

I'm at 7.5.104 Level

Please notify

Thanks a lot

Zan

[Former Member · Accepted solution]

Hi,

You need to login to the BPC server manager in the server machine. Click on the Appset Menu and you will get the option for backup or restore. You can select the desired appsets, there.

Hope this helps.

[Former Member · Accepted solution]

Can I just ask what to do, if when I try to manually back up our production server I get a message box pop-up and no matter if I choose either option the backup won't continue.

No other program has been run, after I logged on to the server. Restart of the server didn't help as well.

Brgrds,

Daniel

[Former Member · Accepted solution]

You have to give time to the server

Your message it is normal

In my case it takes about one hour

[Former Member · Accepted solution]

Ok thanks Michele... I'll try with patience

Only can't remember that I got this message box on any of the earlier back-up sessions.

[Former Member]

HI

When I do the backup the application set will be off-line?

thanks

Michele

[former_member186498]

Hi Michele,

when you do a backup it's better to put offline the appset to be sure that the data don't change during the backup and avoiding data inconsistency.

That's why it's better to do it in the night or in the w.e..

Kind regards

     Roberto

[Former Member]

thanks Roberto

I can't do in the evening because there are other users around the world that could use bpc.

Do I would like to know id I do the backup using Planning and Consolidation Server Manager, the application will be switch off or I can continue to use? Doesn't matter that the backup is not perfect

thanks

regards

Michele

[former_member186498]

Hi Michele,

to do the normal backup of the DB set the DB in full mode, can be scheduled every "x" hours a  differential backup, this doesn't need to stop BPC, on the w.e. it's better to do a full backup, to reduce the time of a restore if it's necessary more then one week back.

If you need to backup all the bpc environment then you should use BPC backup from server manager but in this case you should stop BPC or you risk in case of restore to have a damaged and unuseful backup.

If you can't stop the users then you should do it on the w.e.

Kind regards

     Roberto

[Former Member]

Hola Roberto

IT Person does a daily SQL backup and a full SQL backup at the weekend

When he does the full SQL back up at the weekend I have to put BPC off-line?

thanks

[former_member186498]

Hi Michele,

normally backup is scheduled in the night between saturday and sunday, but if you aren't sure that nobody is working when backup runs then yes.

Regards

     Roberto

[Former Member]

I have this doubt because I look after BPC but the person that look after SQL never asked me to put bpc off-line

I know that there is a daily SQL backup and a weekly full SQL backup but there is the possibility that at the night or at the weekend somebody is working because we have users around the world

So What I have to do? I have to check that he is switching off the sql server when he does the backup?

thanks

[former_member186498]

Hi Michele,

ask first your BASIS, maybe they do it (BPC off) in another way.

Otherwise you can create a simple sql instruction to disable\enable the appsets.

Regards

     Roberto

[Former Member]

thanks Roberto

Is it necessary to put off-line every evening or just at the weekend when they do the full SQL Backup?

[former_member186498]

Hi Michele,

if daily backup is differential it doesn't need to be offline, it can be done also during the day every 3-4 hours, if full then it need bpc off.

Regards

     Roberto

[Former Member]

Nilanjan,

Thanks !! I have drop an email to you, could you advise

Zan