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