SQL VSS Writer Not Listed, Backups Failing

SUMMARY

SQL VSS Writer Not Listed, Backups Failing

ISSUE

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.

 
 
 

RESOLUTION

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

http://support.microsoft.com/kb/919023/en-us

CAUSE

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.

NOTES

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

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us