Symptoms

Application-aware backup of SQL databases finishes with the following warning:

Cannot get the file list of Microsoft SQL database '...'. 

Example of full error log: click to expand

 

MODULE87
MESSAGE Warning
Additional info:------------------------
Error code: 22
Module: 87
LineInfo: 0xB19B368B2754D768
Fields: {"$module":"aavb_mssql_backuper_vsa64_12420"}
Message: Cannot get the file list of Microsoft SQL database 'Acronis'.

Cause

The account used for Microsoft SQL Application-aware backup does not have the 'sysadmin' role on the Microsoft SQL instance. 

Solution

Check that the user account is added to SQL Server security logins and that it has the "sysadmin" role for the SQL instance:

1. Using SQL Management Studio, connect to the SQL instance.
2. Go to Security -> expand Logins
3. Open account properties and switch to Server Roles
4. Mark the sysadmin check box
5. Reattempt the backup

If the solution does not help, collect Acronis System Information from the affected machine and contact Acronis Support with reference to this article.