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.
Article ID: 100013677
Updated On:
Description
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
Resolution
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/content/support/en_US/doc/59226269-132544165-0/v53937162-132544165
Issue/Introduction
Additional Information
