I've recently started Veeam to backup my company's virtualized Microsoft SQL servers. The hypervisor is VMware. My SQL DBAs use a monitoring tool called Idera for their SQL databases which does performance reporting and alerting for them. For two of the three SQL servers, the DBAs are getting fatal alerts from the monitoring tool reporting that the database is down during the backup. The 3rd SQL server does not have these problems. They see the following message on the SQL server during the backup:
I/O is frozen on database. No user action is required. However, if I/O is not resumed promptly, you could cancel the backup.
This is undoubtedly caused by the VSS snapshot process freezing the database in preparation for backup. It may be worth noting that the two SQL servers that have this problem are running 2008 and 2012, but the SQL server that does not have this problem is 2014.
Is there an adjustment I can make in Veeam or on the SQL server to resolve this issue? Is there a Microsoft patch that improves the VSS snapshot process? Is anyone in the community familiar with Idera? Are there monitoring thresholds in Idera that can be modified to suppress these alerts?