Ask the Community
Groups
VSS SQL backup fails - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>This article addresses VSS SQL backup failures.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <p>You receive an error �Unable to perform the scheduled backup: Please verify that the SQL Server instance 'X' is running and database 'Y' is online and has not been excluded from the SQL Server VSS Writer.�</p> <ul></ul><p> </p> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>The tempdb database cannot be backed up. Selecting this database for backup will always result in failure, and it should be de-selected from the schedule. In versions other than v5.1.0 of the DPU software, the tempdb is not selectable for backup.</p> <p>Deleted or renamed databases can be resolved by:</p> <ul><li>Viewing the schedule which ran the backup, and reviewing to see if that database appears with (unavailable) next to its name.</li></ul><p>If this cannot be seen:</p> <ul><li>Confirm that the DPU software is at least version 5.1</li></ul><h2 data-id="cause"><strong>CAUSE</strong></h2> <p></p> <p>When performing a VSS based SQL database backup, this error message usually indicates one of the following:</p> <ul><li>The database 'Y' is called tempdb (Affects <u>v5.1.0</u>)</li> <li>The database named 'Y' has been deleted or taken offline</li> <li>The database named 'Y' has been renamed</li> </ul><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>