Ask the Community
Groups
SQL backups leave partial files after backups - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL differential backup terminates abnormally leaving partial files unnecessarily consuming space.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p>SQL differential backup terminates abnormally leaving partial backup files. </p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p><br>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.<br><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013165237">Performing SQL backups using VDI instead of VSS</a><br><br><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013168877">Unitrends VSS SQL agent errors and warning messages</a></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>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.</p> </article> </main>