Sql Dumps


i am having a problem with sql dumps.
the server is running sql 2005 as well as sql 2008.
when i create a maintenance plan to dump the sql dumps into a folder i have created on the server and execute it . it says Failed .

please assist
Who is Participating?
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
try applying SP3 for SQL Server 2005 and SP1 for SQL Server 2008 and check it out once..
Copy the contents of the error message in history instead of snapshot which might contain any additional information about the error.
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> when i create a maintenance plan to dump the sql dumps into a folder

Kindly let me know what you meant by dumping sql dumps..
Also post the exact error encountered to help you better..
IT_TechnoAuthor Commented:
it says see the logs for details
TITLE: Execute Maintenance Plan

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


Job 'MaintenancePlan.Subplan_1' failed. (SqlManagerUI)



please see the attached file .
i am trying to resolve the log on issues that i see listed in the attached document
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Raja Jegan RSQL Server DBA & ArchitectCommented:
Error message says login failed for KLG\Backup account..
If you are using this account for Backup maintenance task, then reset the password and try running maintenance plan again..
IT_TechnoAuthor Commented:
i have reset the password and it did not resolve the issue .
i changed the user to the administrator and restarted the Sql services but i am still getting a error when i click on execute

please see image attached

IT_TechnoAuthor Commented:
thank you this has resolved the problem
Raja Jegan RSQL Server DBA & ArchitectCommented:
And close this question accordingly..
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.