Sql Dumps

Hi

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
IT_TechnoAsked:
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.
0
 
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..
0
 
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.

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

Job 'MaintenancePlan.Subplan_1' failed. (SqlManagerUI)

------------------------------
BUTTONS:

OK
------------------------------


please see the attached file .
i am trying to resolve the log on issues that i see listed in the attached document
logs.png
0
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..
0
 
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

Untitled.png
0
 
IT_TechnoAuthor Commented:
thank you this has resolved the problem
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Welcome..
And close this question accordingly..
0
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.