SQL database backups fail with the error V-79-10000-10896 - SQL Prepare for Freeze failed for snapshot"
V-79-57344-65268 - AOFO: Initialization failure on: "SQL Server Name". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
V-79-10000-10896 - SQL Prepare for Freeze failed for snapshot.
2. Deselect the option "Use Advanced Open File Option" during SQL backups and re-run the backup.
Create a separate backup job of just the SQL Databases with or without AOFO selected in the job properties. Create another job of all the resources except the SQL Databases with AOFO selected. Make sure both jobs are scheduled to run at different times.
Please note: The SQL VSS Writer backups will usually fail because of the amount of resources VSS is attempting to snap at once, because SQL has a maximum amount of system resources allocated to it, heavy disk fragmentation, lack of available memory, CPU, etc... It is also not necessary to backup SQL Databases with AOFO (SQL VSS Writer), unless it is only desired to restore the entire SQL Instance (all databases) at once from that type of backup.