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

Article:TECH223500  |  Created: 2014-08-04  |  Updated: 2014-08-04  |  Article URL http://www.symantec.com/docs/TECH223500
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



When attempting to backup Microsoft SQL databases the backup fails with the following error messages.


Error



Job Log:
V-79-57344-37951 - Database DATABASE_NAME has failed to freeze for the snapshot backup.

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



Workaround: Use the built in SQL utility to perform backups of the databases.

Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.

This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release. If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns. For information on how to contact Symantec Sales, please see http://www.symantec.com

Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.


Supplemental Materials

SourceUMI
ValueV-79-57344-37951
Description

Database DATABASE_NAME has failed to freeze for the snapshot backup


SourceETrack
Value3585205
Description

SQL: SQL backup fails with Database s failed to freeze for backup.



Article URL http://www.symantec.com/docs/TECH223500


Terms of use for this information are found in Legal Notices