SQL Server 2008 Backup (Maintenance Plan) Failing

Hi there,

I currently have a Web server running Microsoft SQL Server 2008 Databases. When running a one-off backup of the database it runs well and backs up fine. However when I setup a maintenance plan to run a backup it sets up successfully but cannot run. The initial error message is:

TITLE: Execute Maintenance Plan
------------------------------

Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.

------------------------------
ADDITIONAL INFORMATION:

Job 'MaintenancePlan.Subplan_1' failed. (SqlManagerUI)

------------------------------

Now, I can't find any info in the logs even though its supposed to drop something in the program files\sql server directory.

Obviously i',m a bit of a noob at this, but any info or tips would be good.

Cheers
LVL 1
lemonvilleAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark WillsTopic AdvisorCommented:
Which edition of SQL Server is it ? Express cannot run maintenance plans - no SQL Server Agent.

Is the Agent running ? Is there a valid schedule attached ?

In SSMS on the left hand side in Object Browser there should be "SQL Server Agent" expand that to see JOBS and expand that to see your maintenace plans if you double click on one of those, a new window will appear. You can see the jobs and status. On the left of that pop-up there is an entry for SQL Agent and that has a list of the logs.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Ok, do the following:

1. Right click your Agent Job and click view history
2. History would contain detailed information about the error
3. Expand the + sign in your job so that it would list status of job per step.
4. Post the error mentioned in your step to help nail down the issue.

>> When running a one-off backup of the database it runs well and backs up fine

Since you are able to take backup normally, check for the following:

1. Whether Maintenance plan is running under your login or not
2. Whether you have Write permissions to the folder path specified for backup in maintenance plan
0
Mark WillsTopic AdvisorCommented:
Well, not so much "your" login because you say you can run it, more likely the account used for SQL Server Agent cannot see the destination. Check the account that is used to start the SQL Server Agent.
0
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

lemonvilleAuthor Commented:
From what I can tell this is the correct Log.

At the top level it says 'The Job Failed. The Job was invoked by User *PCNAME*\Administrator. The last step to run was step 1 (Subplan_1).

Date            26/10/2010 11:53:40 a.m.
Log            Job History (Backup.Subplan_1)

Step ID            1
Server            *PCNAME*
Job Name            Backup.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
Executed as user: *PCNAME*\Administrator. Microsoft (R) SQL Server Execute Package Utility  Version 10.0.1600.22 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.  The package execution failed.  The step failed.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> The SQL Server Execute Package Utility requires Integration Services to be installed by one of these editions of SQL Server 2008: Standard, Enterprise, Developer, or Evaluation. To install Integration Services, run SQL Server Setup and select Integration Services.  The package execution failed.  The step failed.

Fix here:
http://support.microsoft.com/kb/961126

Install SQL Server Integration Services and make sure that you patch it with SP1 to get it work.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
lemonvilleAuthor Commented:
Actually that's correct, I have yet to install SQL Server 2008 SP1. I'll install now and report back.
0
Mark WillsTopic AdvisorCommented:
good call rrjegan17
0
lemonvilleAuthor Commented:
All Good!. Thanks a bunch!

0
lemonvilleAuthor Commented:
Awesome.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Thanks Mark and lemonville
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.