Maintenance Plan for SQL Server DB Backups are failing

• Siva Ramasamy

  SSCarpal Tunnel

  Points: 4026

  More actions

  February 2, 2012 at 9:57 am

  #252298

  Hi all,

  I am running a named instance of SQL Server 2005 running on a Windows Server 2003.

  I created a maintenance plan to take full backups of the user dbs and saved it.

  I executed the job in SQL Server agent.

  I failed with the following error message..saying syntax error...

  I am surprised about seeing a message saying syntax error.....!!! can you help..

  Date2/2/2012 9:49:46 AM

  LogJob History (DB_Backups.Full_Backups)

  Step ID1

  ServerXXXXXXXXXXXXXXXXXXX

  Job NameDB_Backups.Full_Backups

  Step NameFull_Backups

  Duration00:00:00

  Sql Severity0

  Sql Message ID0

  Operator Emailed

  Operator Net sent

  Operator Paged

  Retries Attempted0

  Message

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

• savethytrees

  SSCommitted

  Points: 1968

  More actions

  February 14, 2012 at 11:18 am

  #1446984

  Check this

  http://saveadba.blogspot.com/2012/02/unable-to-start-execution-syntax-error.html

  If you edit the job anytime in the future you will have to make this change again.

  Blog
  http://saveadba.blogspot.com/