troubleshooting Question

SQL Server 2008 Backup (Maintenance Plan) Failing

Avatar of lemonville
lemonvilleFlag for New Zealand asked on
Microsoft SQL Server 2008Windows Server 2008
10 Comments1 Solution8480 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros