Ask the Community
Groups
After migrating to SQL 2014 the error "writer was not found" - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>Unable to perform a backup of database 'xxxxx', instance 'xxxxx' (writer was not found): The problem occurred while trying to connect SQL Server VSS Writer.</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p><br>After migrated from an older SQL database to SQL 2014, the follow error is received.<br> </p> <pre class="code codeBlock" spellcheck="false" tabindex="0"> ----- Error Messages ----- Unable to perform a backup of database 'xxxxx', instance 'xxxxx' (writer was not found): The problem occurred while trying to connect SQL Server VSS Writer. Please check that the SQL Server VSS Writer is installed and running on the client. If you have any databases with a trailing space at the end of database name, it could cause that SQL Server VSS Writer doesn't list any databases and not be present on your system Error in getting volumes for Vss snapshot or application validation. Failing application backup. Check the System and Application event log on the client server for more information. The Unitrends agent aborted Microsoft SQL Server backup, because agent failed to complete a volume shadow copy operation (create a snapshot). Please review Windows System and Application Event Logs for more information. ----- End Error Messages ----- ----- Client Messages ----- The database xxxxx, instance xxxxx is online. ----- End Client Messages -----</pre> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p>Add the sysadmin role to the "NT AUTHORITY" user and run a new full SQL backup.</p> <h2 data-id="notes"><strong>NOTES</strong></h2> <p>For more information on the sysadmin role, see <a rel="nofollow" href="/home/leaving?allowTrusted=1&target=https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fsecurity%2Fauthentication-access%2Fserver-level-roles">https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles</a>.</p> </article> </main>