September 14, 2009 at 1:21 am
even one of the backup is successful on the prevoius day its showing failed status in the history , how to rectify it?
September 14, 2009 at 1:26 am
Is the Backup only step in the job?
To perform a test, what you can do is take the script out from the job, paste it in the QA and execute. you will must see the results with error.
(Query executed with errors). That is the reason your job is reporting failed.
Not to mention but do this testing in an environment other than production.
September 14, 2009 at 1:29 am
ramyours2003 (9/14/2009)
even one of the backup is successful on the prevoius day its showing failed status in the history , how to rectify it?
If it is a backup job that is failing now and again, it is a good chance that it will be network related, check the error in the history, it will tell you the reason for failure.
--------------------------------------------------------------------------------------
[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]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply