V-79-57344-37951 - Backup of Microsoft SQL databases fails with V-79-57344-37951 - Database DATABASE_NAME has failed to freeze for the snapshot backup.

Problem

When attempting to back up Microsoft SQL databases the backup job fails with error messages.

Error Message

Job Log:
V-79-57344-37951 - Database has failed to freeze for the snapshot backup. The SQL database may fail to freeze if there are issues such as insufficient memory, an out of disk space error occurs, or the user account does not have the appropriate permissions

Debug Logs:
[fsys\sql2]          - SQL2_PrepareForFreeze: Starting on database DATABASE_NAME.
[fsys\sql2]          - SQL2_PrepareForSnapBackup: Could not create component: x800700C1
[fsys\sql2]          - PrepareForFreeze failed on DATABASE_NAME.
[fsys\sql2]          + sql2snapback.cpp (203):
[fsys\sql2]          | Database %s failed to freeze for backup
 

Solution

SQL database backup jobs may fail if the credentials for the Windows server that SQL Server is installed on does not have sufficient rights to access SQL Server. Backup Exec uses Windows server credentials and the account may not have permissions to access the SQL Server. Ensure that the credentials used for SQL database backup jobs has been granted the appropriate permissions.

Requirements for using the SQL Agent

https://www.veritas.com/support/en_US/doc/59226269-132544165-0/v53937162-132544165