Ask the Community
Groups
Unable to perform backup operation, detecting that SQL Server VSS Writer is in failed state - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Unable to perform backup operation, detecting that SQL Server VSS Writer is in failed state</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <h3 data-id="purpose">Purpose</h3> <p>This article discusses an issue that SQL database backups may fail with the error “Unable to perform backup operation, detecting that SQL Server VSS Writer is in failed state.”</p> <h3 data-id="applies-to">Applies To </h3> <p>Unitrends appliance 6.1 and higher<br>Unitrends agent 6.1 and higher<br>MS SQL 2005 and higher</p> <h3 data-id="symptoms">Symptoms</h3> <p>Error displayed in the Application Event log:</p> <p><span style="font-family: courier;">Jun 17 11:09:22 : (Waiting for the asynchronous operation to finish...)<br>Jun 17 11:09:22 : Unitrends SQL Server agent error: Selected writer 'SqlServerWriter' is in failed state!<br>- Status: 8 'VSS_WS_FAILED_AT_PREPARE_SNAPSHOT'<br>- Writer Failure code: 0x00000000 (S_OK)<br>- Writer ID:'{a65faa63-5ea8-4ebc-9dbd-a0c4db26912a}'<br>- Instance ID:'{e064f6dd-2c84-4001-b9cf-33d5e5687d49}'<br>Jun 17 11:09:22 : 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>Jun 17 11:09:22 : Unitrends SQL Server agent fails to initialize backup.</span></p> <p><span style="font-family: courier;">Application event log:<br>Event ID: 24582<br>Source: SQLWriter</span></p> <p><span style="font-family: courier;">Sqllib error: Failed to create VDS object. hr = 0x80770005.</span></p> <h3 data-id="resolution">Resolution</h3> <p>To resolve this problem, configure the startup account of the SQL Server service to use the LocalSystem account. Alternatively, use a startup account that has the full name of the domain account instead of a period (.) to start the service. For example, use the startup account DomainName\UserName to start the service.</p> <p> </p> <p>Always use SQL Server Configuration Manager to change the account used by the SQL Server, or to change the password for the account. In addition to changing the account name, SQL Server Configuration Manager performs additional configuration such as setting permissions in the Windows Registry so that the new account can read the SQL Server settings. Other tools such as the Windows Services Control Manager can change the account name but do not change associated settings. If the service cannot access the SQL Server portion of the registry, the service may not start properly.</p> <p><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Fconfigure-windows%2Fconfigure-windows-service-accounts-and-permissions">https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions</a></p> <h3 data-id="third-party-resources">Third-Party Resources</h3> <p> </p> <p><a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdatabase-engine%2Fconfigure-windows%2Fconfigure-windows-service-accounts-and-permissions">https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions</a></p> </article> </main>