SQL VSS Writer Not Listed, Backups Failing


SQL VSS Writer Not Listed, Backups Failing


Applies To

SQL Server and MSDE

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.

Source: http://blogs.msdn.com/b/batala/archive/2011/08/01/sqlserverwriter-missing-when-vssadmin-list-writers-command-is-run.aspx

SQL server will fail with error 0x08000ffff or an unknown error. Typically SQL was working before and it will happen all of the sudden.



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.

This query may help find databases with the leading or trailing “ “ white space.

select '#' + name +'#'  from sys.databases

Third-Party Sources



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.


For more detailed information on backup failures and performance issues see Unitrends KB 5062 - Backup Failures and Performance Issues

Have more questions?

Contact us

Was this article helpful?
0 out of 0 found this helpful

Provide feedback for the Documentation team!

Browse this section