topic Blueprism Backup database for exception handling in Product Forum

Blueprism Backup database for exception handling

SANJIBSINHA — Tue, 20 Aug 2019 02:26:00 GMT

Is there any way to create Blueprism real-time production Backup database for disaster recovery.

------------------------------
SANJIB SINHA
Software Senior Engineer

Asia/Kolkata
------------------------------

RE: Blueprism Backup database for exception handling

AmiBarrett — Tue, 20 Aug 2019 14:10:00 GMT

If you don't mind altering all of the tables, you could put insert/update triggers on each table to point to another Schema.

------------------------------
Ami Barrett
Lead RPA Software Developer
Solai & Cameron
America/Chicago
------------------------------

RE: Blueprism Backup database for exception handling

SuyogDoshi — Tue, 14 Jul 2020 19:57:00 GMT

Thanks @Ami Barrett,
Is database backup alone sufficient for DR setup? Do we need any other file system backup for Dr?

------------------------------
Suyog Doshi
RPA Architect
LTI
Asia/Kolkata
------------------------------

RE: Blueprism Backup database for exception handling

chris.mcgowan — Wed, 15 Jul 2020 08:42:00 GMT

Hi Sanjib,

For Disaster Recovery you need to consider two main points;

Recovery Point Objective - How much data can you afford to loose
Recovery Time Objective - How long it takes to recover

There are numerous ways to achieve Disaster Recovery of the Blue Prism database and the two objectives above will dictate which solution is required. Please see the below Microsoft documentation on the subject for more detail.

https://docs.microsoft.com/en-us/sql/database-engine/sql-server-business-continuity-dr?view=sql-server-ver15

In Short you can use;

Always on availability groups (One of the benefits of availability groups is that both high availability and disaster recovery can be configured using a single feature).
Always on failover cluster instances
Log Shipping

------------------------------
Chris McGowan
Senior Technical Consultant
Blue Prism
------------------------------