One of the SQL backup job failing with the error : Unable to connect to SQL Server '(local)'. The step failed. . I was trying to take backup of ‘Test’ database, after seeing this error verified again and noticed the DB ‘Test’ exists and is accessible without any issue.
After verifying, noticed job step was configured in this way:
I have changed the ‘Database:’ option to ‘Master’ :
and ran the job again. It went fine without any issue and I was able to take backup of the Test DB without any issue. The error in job history looks bit weird but actual issue is the job step is referring to same DB for which it is taking backup. For my issue this worked.
thx .. it worked
ReplyDeleteGlad it helped you!!!
Delete