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

4 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