Restore of an application without having an OLAP database backup

[Former Member]

Hello,

Could you tell me if there is a means (manually or through the server manager) to restore a working application-set if I have not a backup of the OLAP database ?

Thanks in advance,

Lionel

[Former Member · Accepted solution]

Hi,

There is a way :

On the server hosting BPC Server Manager :

1. Create a new folder named "MyAppSet" where MyAppSet is the exact name of your appset.

2. Create 3 sub-folders, in the previous one, named WebFolder, FileDB and SQL

3. In \MyAppset\Webfolder put a zip file contening all the files and subdirectory of the appset webfolder

4. In \MyAppset\FileDB put a zip file contening all the files and subdirectory of the appset fileDB

5. in \MyAppSet\SQL put the .BAK file of your DB (full backup of your appset.

6. Run SAP BPC server manager => AppSet => Restore AppSet

7. Open \MyAppSet directory.. This will automatically find the correct filedb zip, webfolder zip and DB .BAK file

SSAS DB will be recreated but you will have to reprocess application / dimensions and security from the Admin client.

[Former Member · Accepted solution]

Hello,

Thank you very much for this reply, it's very interesting. I will try this.

Kind regards,

Lionel