Hybrid DC-to-DR MSSQL Replication
Budget: ₹1,500 – ₹12,500 INR
I need help turning my hybrid environment—part on-prem, part cloud—into a reliable disaster-recovery setup for our Microsoft SQL Server database (currently under 500 GB). The goal is simple: every committed transaction in the primary data-center must be captured immediately and be ready for fail-over at the DR site.
Here is what I expect:
• Configure log shipping and an Always On availability group so that replication is continuous and automatic.
• Validate the configuration with a controlled fail-over test.
• Build a lightweight monitoring routine that alerts the team if latency, queue length, or synchronization state drifts from healthy thresholds.
• Deliver clear, step-by-step documentation—including screenshots of every critical dialog or script run—so future troubleshooting is straightforward.
Please keep best practices in mind for hybrid topologies, secure endpoints, and minimal performance impact on production.
Here is what I expect:
• Configure log shipping and an Always On availability group so that replication is continuous and automatic.
• Validate the configuration with a controlled fail-over test.
• Build a lightweight monitoring routine that alerts the team if latency, queue length, or synchronization state drifts from healthy thresholds.
• Deliver clear, step-by-step documentation—including screenshots of every critical dialog or script run—so future troubleshooting is straightforward.
Please keep best practices in mind for hybrid topologies, secure endpoints, and minimal performance impact on production.