Your overall design is sensible, but Databricks’ current recommendation is to use Managed Disaster Recovery when your account is eligible. If Managed DR is unavailable, use an active-passive warm standby with Terraform/DABs, cross-region data replication, and a tested failover runbook. Your separate North Europe and West Europe workspaces/metastores are a normal pattern, and both regions are listed as supported for Managed DR.
The main caution is that a nightly copy alone does not guarantee a 24-hour RPO/RTO. You must also recover pipelines, streaming state, dashboards, models, sharing, networking, and other dependencies that are not automatically replicated
Thank You
Pradeep Singh - https://www.linkedin.com/in/dbxdev