Blueprism Backup database for exception handling

[SANJIBSINHA]

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

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

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

[AmiBarrett]

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
------------------------------

[SuyogDoshi]

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
------------------------------

[chris.mcgowan · Accepted solution]

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
------------------------------