Ask the Community
Groups
SQL VSS Writer Not Listed, Backups Failing - Connect IT Community | Kaseya
<main> <article class="userContent"> <h2 data-id="summary"><strong>SUMMARY</strong></h2> <p>SQL VSS Writer Not Listed, Backups Failing</p> <h2 data-id="issue"><strong>ISSUE</strong></h2> <p></p> <p><b>Applies To</b></p> <p>SQL Server and MSDE</p> <p><i>If the database names are fine, check that SYSADMIN is a member of NT AUTHORITY\SYSTEM. If not, add SYSADMIN to SYSTEM, and restart the SQL Server VSS Writer Service. The SqlServerWriter should now be listed in Stable/No-Error in vssadmin list writers. Run a test backup to make sure everything is functioning.<br><br>Source: <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fblogs.msdn.com%2Fb%2Fbatala%2Farchive%2F2011%2F08%2F01%2Fsqlserverwriter-missing-when-vssadmin-list-writers-command-is-run.aspx">http://blogs.msdn.com/b/batala/archive/2011/08/01/sqlserverwriter-missing-when-vssadmin-list-writers-command-is-run.aspx</a></i></p> <p>SQL server will fail with error 0x08000ffff or an unknown error. Typically SQL was working before and it will happen all of the sudden.</p> <div> </div> <div> </div> <div> </div> <h2 data-id="resolution"><strong>RESOLUTION</strong></h2> <p></p> <p>To Resolve the SQL VSS writer from disappearing you would have to remove or rename the database to something without spaces understand if you have do not remove the “ “(space) the VSS writer will stay in a hidden and failed state Until otherwise.</p> <p>This query may help find databases with the leading or trailing “ “ white space.</p> <p><b>select '#' + name +'#' from sys.databases</b></p> <h3 data-id="third-party-sources">Third-Party Sources</h3> <p><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F919023%2Fen-us">http://support.microsoft.com/kb/919023/en-us</a></p> <h2 data-id="cause"><strong>CAUSE</strong></h2> <p>SQL database do not work with a trailing “ “ space or with a space in conjunction with a “ “ space for example if I had a database named “My Big Database” or “MYBIGDATABASE “ the SQL VSS writer would not be there.</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>