Sunday, February 1, 2026

YES, you can configure backups on secondary node of AG now.

 Hi Friends,

If you’ve worked with SQL Server high availability, you know that Always On Availability Groups, introduced in SQL Server 2012, brought a major leap forward in HADR capabilities. However, one long-standing limitation always held us back—we couldn’t run a complete backup strategy on the secondary replica.

Yes, we could take copy_only full backups and transaction log backups on secondary replicas, but differential backups and normal full backups were restricted to the primary. As a result, DBAs were forced to run complete backup cycles on the primary node to maintain point‑in‑time restore capability.

And this came with challenges:

  • Backups consume CPU, I/O, and memory, often slowing down regular database transactions.
  • For 24×7 workloads, finding the “perfect time” for backups on the primary was often impossible.
  • Offloading backups to a replica wasn’t fully feasible because of those limitations.


SQL Server 2025 Changes Everything

With SQL Server 2025, this limitation is finally gone!

You can now run all backup types on a secondary replica, including:

  • ✔️ Normal Full Backup
  • ✔️ Copy_only Full Backup
  • ✔️ Differential Backup
  • ✔️ Transaction Log Backup

This means you can completely shift your backup strategy to the secondary node, keeping the primary replica laser‑focused on serving application workloads. For busy OLTP systems, this is a massive win.

How to Enable This Feature

To unlock this functionality, enable the following TRACE flags on the respective secondary node:

  • 3261 – Enables differential backups on secondary replicas
  • 3262 – Enables full backups on secondary replicas

Once these are enabled, your backup strategy is fully offloadable to the secondary node.

Final Thoughts

This enhancement is going to be a game‑changer for SQL Server administration. Reduced load on the primary, better performance for applications, and far more flexible backup scheduling—what more can we ask for?

That’s all for today. See you in the next blog — Happy learning! 🚀

No comments:

Post a Comment