asked on

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

Raja Jegan R

>> 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_Techno

ASKER

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

Raja Jegan R

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_Techno

ASKER

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

ASKER CERTIFIED SOLUTION

Raja Jegan R

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

IT_Techno

ASKER

thank you this has resolved the problem

Raja Jegan R

Welcome..
And close this question accordingly..