Onestream dailys and weekly backups / restores

ghizlanemnafe
New Contributor

Hello,

I want to schedule daily and weekly backups/restores for the OS application. This backup would be used to restore the whole application if something had to happen. There's an extensibility rule that can be scheduled to extract all the application artefacts. The rule has some limitations as it extracts artefacts but not the data.

 

Is there a way to create daily backup of the whole application including the data ?

5 REPLIES 5

Henning
Contributor III

Hi,

are we talking about a cloud customer or on-premise? In the OneStream cloud, backups are part of the offer. So what you describe is typically included and you can just reach out to support to restore one of your apps from the cloud. 

On-premise, this is easier directly on the server. A Google search such as but not limited to "sql automatic backup" provides more examples.

NicolasArgente
Valued Contributor

Please look at your contract to know how long are kept the back up.

Connect with me on:
LinkedIn: https://www.linkedin.com/in/nicolas-argente/
Website: https://aiqos.io
If you want to lift yourself up, lift up someone else.

ghizlanemnafe
New Contributor

Hello, 

thank you for your answers, 

i am aware that in Cloud and as per the contract with OS, we have backups with the offer. however, we want to do our "own" backups (whole app including data). It would be an alternative to reach OneStream support to restore one of the backups each time we wanna have a restore... is it possible to have something like that through ext rules or another way in the app (it's for a cloud customer)?  

thank you in advance 

Hi, so for a cloud customer you still wish to create additional backups? I recommend not doing that. 

If you do that, you duplicate the entire application and block more space on the server. Also, once you did that, the file is stored on the server and you'd still need to reach out to the cloud support team to tell them to use your copy and replace the tables from there in the app you wish to overwrite.

I do not see why an alternative is needed for "each time we wanna have a restore". This usually does not happen very often anyway (i.e. almost never, unless someone who is not qualified messes with the app). And even if it does, the cloud support path is the safer option.

The cloud service should more than suffice. Their response time is great!

Don_Lovett
New Contributor

 

You can use the SQL Server Agent from the SQL Server Management Studio if you have an Enterprise SQL Server License and have provided the agent with connectivity to the OneStream Database Tables.  The Jobs to backup the database can be established with a wizard.  This will capture the data portion and the 3 config files in the application should also be backed-up.  Please see the installation instructions for more information.

Backup Agent SSMSBackup Agent SSMS