Microsoft SQL Server Requirements for Application-Aware Backups

For Microsoft SQL Server, you can use the database agent to restore a database.

You can perform application-aware backups for standalone deployments of Microsoft SQL Server, or for the primary replica in an AlwaysOn Availability Group as configured in SQL Management Studio. For more information, see Best Practices for Application-Aware Backups for Microsoft SQL Server.

Application-aware backups using the Virtual Server Agent are supported for the versions of SQL Server that are listed in Microsoft SQL Server.

You cannot perform application-aware backups for a 32-bit SQL server application on a 64-bit operating system.

Application Credentials

To perform backups and restores for SQL Server databases, SQL sysadmin rights are required.

VM Group Configuration

Include virtual machines running Microsoft SQL Server in a separate VM group.

Log Truncation

For Microsoft SQL Server, an automatic log backup schedule is created automatically after you run an application-aware backup successfully for the first time.