SQL database backups fail with the error - SQL Prepare for Freeze failed for snapshot"

Article:TECH68517  |  Created: 2009-01-05  |  Updated: 2012-05-14  |  Article URL http://www.symantec.com/docs/TECH68517
Article Type
Technical Solution


Issue



SQL database backups fail with the error V-79-10000-10896 - SQL Prepare for Freeze failed for snapshot"


Error



V-79-57344-65268 - AOFO: Initialization failure on: "SQL Server Name". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
V-79-10000-10896 - SQL Prepare for Freeze failed for snapshot.


Solution



The above error is generated while performing a backup of Microsoft SQL database with the Advanced Open File Option (AOFO) selected in the Backup Job Properties.
 
Solution 1:
 
Create a backup job of all the resources on the SQL Server without AOFO selected:
 
1. On the Backup Job Properties pane, under Settings, click Advanced Open File.
2. Deselect the option "Use Advanced Open File Option" during SQL backups and re-run the backup.


Solution 2:

Create a separate backup job of just the SQL Databases with or without AOFO selected in the job properties.  Create another job of all the resources except the SQL Databases with AOFO selected.  Make sure both jobs are scheduled to run at different times.

Please note:  The SQL VSS Writer backups will usually fail because of the amount of resources VSS is attempting to snap at once, because SQL has a maximum amount of system resources allocated to it, heavy disk fragmentation, lack of available memory, CPU, etc...  It is also not necessary to backup SQL Databases with AOFO (SQL VSS Writer), unless it is only desired to restore the entire SQL Instance (all databases) at once from that type of backup.  

 

Supplemental Materials

SourceUMI
ValueV-79-10000-10896
Description

SQL Prepare for Freeze failed for snapshot


SourceUMI
ValueV-79-57344-65268
Description

AOFO: Initialization failure on: "SQL Server Name". Advanced Open File Option used: Microsoft Volume Shadow Copy Service (VSS).
 



Legacy ID



320694


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


Terms of use for this information are found in Legal Notices