Monday, August 8, 2011

Unable to start execution of step 1 (reason: line(1): Syntax error)

You may receive the error “Unable to start execution of step 1 (reason: line(1): Syntax error” under below circumstances in SQL Server 2005/2008.
1. Created a new maintenance plan
2. Modified the path in existing maintenance plan
3. Existing database fails due after File servers IP Change..etc

Here is the complete error message:
Execution failed. See the maintenance plan and SQL Server Agent job history logs for details:
Additional Information:
Job ‘ Log_Backup’ failed. (SqlManagerUI)

Additional information from Log File Viewer:-
Executing the query "EXECUTE master.dbo.xp_create_subdir N'\\\\backup\\t..." failed with the following error:"Cannot open backup device \\backup\testdb.trn'. Operating system error 53(The network path was not found.). BACKUP LOG is terminating abnormally.” Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

Solution:
1. Check the login used to schedule the backup has access to backup device path and read/write permissions.

Run below t-sql from New Query to check the permission.
EXECUTE master.dbo.xp_create_subdir N'\\backup \testdb'

2. If your Backup Maintenance plan suddenly stopped working after Network maintenance then it may be related to name resolution to File Server Name or IP Change or Alias name that you are using in the backup.

Check whether you are able to resolve correct name, IP address using nslookup or check with your Windows team to fix name resolution.
For ex:- nslookup "server name or IP address or File server name"

3. If you still have issues
- Go to SQL Server Agent\Jobs and click properties
- Go to Steps section
- Highlight the Sub plan and click Edit
- In the “ package section” add a Backslash to the beginning of the path listed

Regards
Satishbabu Gunukula
http://www.sqlserver-expert.com

8 comments:

  1. Wow! Thank you! I always needed to write on my blog something like that. Can I include a fragment of your post to my website? social media marketing


    ReplyDelete
  2. Terrific work! This is the type of info that should be shared around the internet. Shame on Google for not positioning this post higher! Come on over and visit my site . Thanks =) Mobile friendly and responsive design

    ReplyDelete
  3. I do not even know how I ended up here, but I thought this post was great. I do not know who you are but definitely you're going to a famous blogger if you are not already ;) Cheers! top-notch customer service

    ReplyDelete
  4. You made some respectable points there. I regarded on the web for the difficulty and found most people will go along with together with your website. advertising agencies singapore

    ReplyDelete
  5. Hey there I am so thrilled I found your website, I really found you by error, while I was browsing on Askjeeve for something else, Anyhow I am here now and would just like to say kudos for a remarkable post and a all round enjoyable blog (I also love the theme/design), I don’t have time to look over it all at the moment but I have bookmarked it and also added your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome work. Titanium Pipe

    ReplyDelete
  6. Hi there, You've done a fantastic job. I will certainly digg it and personally suggest to my friends. I am confident they'll be benefited from this website.icl singapore

    ReplyDelete
  7. I truly like what you folks will in general be up as well. This sort of sharp work and inclusion! Keep up the incredible works folks I've joined you all to my own blogroll.

    bolts and nuts

    ReplyDelete
  8. What i don't realize is actually how you're not actually much more well-liked than you might be now. You are very intelligent. You realize thus considerably relating to this subject, made me personally consider it from so many varied angles. Its like men and women aren't fascinated unless it’s one thing to accomplish with Lady gaga! Your own stuffs excellent. Always maintain it up!corporate tax services singapore

    ReplyDelete