Re: SQL 2005 - Backup Maintainance Plan Failed

Tech-Archive recommends: Fix windows errors by optimizing your registry

Simon,

I see that the last part of this says "syntax error". I have no idea what
that is, of course.

If step 1 is a TSQL step such as Check Database Integrity or Backup
Database, then from the Maintenance Plan editor you can click on the
properties and use [View TSQL] button to look at the code. Maybe that
would help.

RLF
"Simon" <Simon@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23pNsG841HHA.5772@xxxxxxxxxxxxxxxxxxxxxxx
Hi

We have a new instance of SQL Server 2005 and have created a backup
maintainance plan which is failing with these errors.

I am not sure what the problem could be.

Any advice would be much appreicated

Thanks
B

Date 05/08/2007 19:27:50
Log Job History (DailyFullBackup.Subplan_1)

Step ID 0
Server SERVERName\MSSMLBIZ
Job Name DailyFullBackup.Subplan_1
Step Name (Job outcome)
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. The Job was invoked by User DOMAIN\administrator. The
last step to run was step 1 (Subplan_1).


Date 05/08/2007 19:27:50
Log Job History (DailyFullBackup.Subplan_1)

Step ID 1
Server Server\MSSMLBIZ
Job Name DailyFullBackup.Subplan_1
Step Name Subplan_1
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

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




.

Quantcast