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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> 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
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

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
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
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

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
IT_TechnoAuthor Commented:
thank you this has resolved the problem
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Welcome..
And close this question accordingly..
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 2005

From novice to tech pro — start learning today.