Hello Guys, In one of my recent SharePoint 2016 deployment (hosted on Azure VMs), we ran across an issue in which SQL Server 2014 managed backup was enabled for SharePoint databases. The size of all the databases combined was about 2 TB! The problem started when users started using the SharePoint application extensively, resulting in SQL transaction logs getting filled more frequently and hence SQL Managed backup triggering full backups of such databases during peak business hours multiple times. Now, whenever the backup used to get started, the communication between SharePoint server and SQL server started to show issues like […]
How to ensure SharePoint performance during SQL backups
