Ask the Community
Groups
SQL Full backup failing with snapshot failure due to insufficient space on databases volume - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL Full backup failing with snapshot failure due to insufficient space on databases volume</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <p>SQL Full backup failing with snapshot failure due insufficient space on databases volume</p> <p>FATAL: No backup data received from client.<br>----- Error Messages -----<br>Unable to perform backup operation, detecting that SQL Server VSS Writer is in failed state. Please verify that SQL Server is accessible. Review the events in the Application event log for more information<br>Writer: 'SqlServerWriter':<br>- Status: 8 'VSS_WS_FAILED_AT_PREPARE_SNAPSHOT'<br>- Writer Failure code: 0x800423f3 (VSS_E_WRITERERROR_RETRYABLE)<br>- Writer ID:'{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}'<br>- Instance ID:'{595479bd-a258-4bd6-88b7-6ac097eb4d68}'<br>----- End Error Messages -----</p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p>Free space on volume<br>OR<br>Move databases to a different volume:<br>Refer to Microsoft SQL documentation at <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fdatabases%2Fmove-system-databases">https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases</a> and <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fdatabases%2Fmove-user-databases">https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases</a><br>OR<br>Manually perform database shrinking<br>Refer to Microsoft SQL documentation at <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fprevious-versions%2Fsql%2Fsql-server-2008-r2%2Fms189080%28v%3Dsql.105%29">https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms189080(v=sql.105)</a></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>Limited space on volume</p> <h2 data-id="notes"><strong>NOTES</strong></h2> <p>For more detailed information on backup failures and performance issues see <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Funitrends-support.zendesk.com%2Fhc%2Fen-us%2Farticles%2F360013174757">Unitrends KB 5062 - Backup Failures and Performance Issues</a></p> </article> </main>