Summary
SQL Block backup job fails. Block Backup Window does not list SQL" object. File browser continues to list "SQL" object. "
Symptoms
An Block backup job has been defined. The job fails to run and generates following log (truncated for brevity):
Error in expanding the job definition, make sure jobdef matches current discover output
Func(backup_): Exception (problem in expanding jobdef comp (/SQL), selectSingleNode() couldn't find the node for (/disc_resp/volnode[@nameval="SQL"]) )
Backup tasks for node(ed_isd_sql1) will be skipped because of resolution failure
Resolution
Run vssadmin list writers from the command prompt. The following output is generated.
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line too
(C) Copyright 2001 Microsoft Corp.
Waiting for responses.
These may be delayed if a shadow copy is being prepared.
Writer name: 'MSDEWriter'
Writer Id: {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
Writer Instance Id: {0a078de0-f394-43c2-9089-b511348bd669}
State: [9] Failed
Last error: Not responding
This indicates that MSDEWriter, responsible for SQL VSS operation, failed to respond.
Restart Microsoft Software Shadow Copy Provider & Volume Shadow copy services. Please note that restarting service may be a disruptive operation. Consult server owner before restarting services.
After services are restarted run vssadmin list writers from the command prompt:
vssadmin 1.1 - Volume Shadow Copy Service administrative command-line tool
(C) Copyright 2001 Microsoft Corp.
Writer name: 'System Writer'
Writer Id: {e8132975-6f93-4464-a53e-1050253ae220}
Writer Instance Id: {fcb1e2b0-0b3a-42ba-a1e6-265765d155f4}
State: [1] Stable
Last error: No error
Writer name: 'MSDEWriter'
Writer Id: {f8544ac1-0611-4fa5-b04b-f7ee00b03277}
Writer Instance Id: {aa71c3d0-2b96-471a-80fd-d515d7b34850}
State: [1] Stable
Last error: No error
After restarting services, backup job will complete successfully.