RTO is 8 hours
RPO is 24 hours
Retention Period: 5 days
Based on above values I have plan to configure below backup stratgey for Production. Please suggest if there is any changes required in below backup policy.
Full Backup – Daily
Log Backup – every 30 minutes (this is just to prevent log grwoth/low disk problems during index rebuild job)
SQL DB size is approx 500-650 GB.
HA/DR solution for above DB: Configured Distributed Always-ON AG from DC1 to DC2 on top of WSFC (DC1- two DB serevrs and DC2-two DB servers)