Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 405
  • Last Modified:

SQL 2008 stan Maintenance Plans won't run

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.
0
PerfectImageSupport
Asked:
PerfectImageSupport
1 Solution
 
Eugene ZCommented:
install sp1 for sql server 2008:

delete and recreate your maint plan ...
0
 
PerfectImageSupportAuthor Commented:
Thanks for your help, it was an sp1 issue
0

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

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