SQL backups leave partial files after backups

SUMMARY

SQL differential backup terminates abnormally leaving partial files unnecessarily consuming space.

ISSUE

SQL differential backup terminates abnormally leaving partial backup files.  

RESOLUTION


There are two approaches to correcting this issue.  Either, the underlying VSS errors can be addressed or the Unitrends agent can be configured to use VDI to perform the backup rather than relying on the VSS writers.

Performing SQL backups using VDI instead of VSS

Unitrends VSS SQL agent errors and warning messages

CAUSE

This condition typically occurs when a SQL differential backup terminates abnormally.  The backup may not complete due to space constraints on the SQL server where the VSS snapshot is being stored, a network disconnection or another VSS error which can be found in the Event Viewer of the SQL server.

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section