October 2, 2009 at 12:59 am
hi experts,
I found that two of my backup jobs created using maintenance plan task was running for almost tow days.
Today it stopped and thrown error
Executed as user: sqlserver12\user. The return value was unknown. The process exit code was 128. The step failed.
Please note that both of my task have maintenance cleaning task to delete ,bak files older than 3 days
Please help.....
Tanx 😀
October 2, 2009 at 3:34 am
Eswin (10/2/2009)
hi experts,I found that two of my backup jobs created using maintenance plan task was running for almost tow days.
Today it stopped and thrown error
Executed as user: sqlserver12\user. The return value was unknown. The process exit code was 128. The step failed.
Please note that both of my task have maintenance cleaning task to delete ,bak files older than 3 days
Please help.....
Sounds like either a security or memory issue, is there anything in the event logs and what step did it fail on. and should the job take that long to run.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 2, 2009 at 6:17 am
That was the error found in error log.
Im not sure of the security issues but there was around 20 GB of free memory in the server.
The step at which the job failed was step one ie backup job
Tanx 😀
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply