<ul><li>SQL Server 2025 introduces the ability to perform normal Full backups and Differential backups on secondary replicas of an availability group.</li><li>Before SQL Server 2025, limitations existed in performing Full and Differential backups on secondary replicas.</li><li>New trace flags 3261 and 3262 need to be enabled to perform these new backups on secondary replicas.</li><li>This enhancement allows for offloading backup workload from the primary replica to the secondary, providing more robust backup configurations.</li></ul>

SQL Server 2025 – Backups to secondary replicas of an availability group

Discover more