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:

sqlvss1

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.
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. 

sqlvss3
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
Advertisements

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: