SQL 2008 stan Maintenance Plans won't run

Posted on 2009-04-16
Last Modified: 2012-05-06
We have just installed SQL server 2008 standard as and upgrade to 2005 on an SBS 2003 server.

I can set up the maintenance plans ok for backups etc but when I execute the plans they fail at step 1. I have set up reporting for the plan but no file gets written, and nothing appears in either the maintenance plan history or job history.

Interestingly, I scripted out the plan and ran it as a query and it worked fine.

I have tried this with SQL agent running as  local system account, or the domain administrator that I ran the scripting fine with.
Question by:PerfectImageSupport
    LVL 42

    Accepted Solution

    install sp1 for sql server 2008:

    delete and recreate your maint plan ...

    Author Closing Comment

    Thanks for your help, it was an sp1 issue

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Suggested Solutions

    I’m often asked about newer and larger USB drives connected to SBS2008 and 2011 failing Windows Server Backup vs the older USB drives not failing. As disk space continues to grow and drive technology change SBS2008 and some SBS2011 end up with the f…
    You may have discovered the 'Compatibility View Settings' workaround for making your SBS 2008 Remote Web Workplace 'connect to a computer' section stops 'working around' after a Windows 10 client upgrade.  That can be fixed so it 'works around' agai…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    737 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

    17 Experts available now in Live!

    Get 1:1 Help Now