• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 321
  • Last Modified:

Maintence Plan Error

I have created a simple Maintence plan to - Check database integrity
                                                                   - Backup database
On Executing the plan I get a 'Execution Failed' Error
The log for this Maintence plan is as follows -  ' Unable to start execution of step 1 (reason: line(1): Syntax error). the step failed. ?

If I manually copy the T-SQL for both steps of the Maintence plan into a new query and execute the query, it completes both steps without error???

we have had more advanced maintence plans working on a schedule for some time without issue. these produce the same error as above.
I am using MS SQL 2005 Management studio ver 9.00.3042.00
Our SQL 2005 server is within my LAN and version 9.0.1399
0
eonic
Asked:
eonic
1 Solution
 
DBAduck - Ben MillerPrincipal ConsultantCommented:
Why is the version of the SQL Server .1399?  That is not SP2 and there are many things that you should update your SQL Server for.  You may find that it could be an issue with the version of SQL Server, not the tools (your tools are SP2).
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now