Maintence Plan Error

Posted on 2008-11-11
Last Modified: 2012-05-05
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
Question by:eonic
    1 Comment
    LVL 24

    Accepted Solution

    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).

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    SQL 2014 and VB 2015 4 38
    Group by correlation 4 41
    SQL HELP 2 65
    Stored procedure 4 21
    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now