The job has been cancelled because of the failure of another job on which it depended. (ID 912)

Problem:

Using Microsoft Data Protection my SQL backups started failing.  The failed jon log said

The job has been cancelled because of the failure of another job on which it depended. (ID 912) 

Cause:

The SQL VSS writer enters a bad state.  To make sure this is your problem open an administrative command prompt and type the following:

If you SQL Writer is in a bad state it will not show up in the list of VSS writers. 

If you see this, your SQL Writer is stable. If not, you need to restart the SQL Writer.

Solution:

To restart the SQl Writer, type the follwoing two commands. 

Once your the SQL Writer has been successfully restarted, check to see if the writer is now listed by typing:

vssadmin list writers

Once your SQL writer is listed as Stable you will be able to successfully protect your SQL DBs again

Advertisement