September 22, 2009 at 1:24 am
we ve some backup jobs which runs daily night at 9pm , even the jobs are running fine. status is displayed as failed in job history , what are the possible reasons for this and how to resolve this situation
September 22, 2009 at 1:33 am
ramyours2003 (9/22/2009)
we ve some backup jobs which runs daily night at 9pm , even the jobs are running fine. status is displayed as failed in job history , what are the possible reasons for this and how to resolve this situation
without seeing what it says in history, hard to say. could be one step that fails, like a email notification step at the end of the job, or maybe one of the steps is set to report failure instead of success
--------------------------------------------------------------------------------------
[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]
September 22, 2009 at 1:39 am
email is not established , mail is not configured , how to resolve this .
September 22, 2009 at 1:42 am
Seems like your job is able to backup but one or many of its steps or Part is raising error message. To trouble shoot, pull out the script in QA and run it from Query window and you will see there the result that "Query Executed with Errors".
Another method can be to diagnose your SQL Server Error logs.
September 22, 2009 at 1:56 am
after all i got a doubt at your backups! are they valid ?
Some times backups may fail at completion time, then it will give a backup but that might not be valid.
So please check the backup state by below query
Restore headeronly from disk='bakcup file locaton.bak'
Restore filelistonly from disk='bakcup file locaton.bak'
September 22, 2009 at 2:04 am
all backups are vaild , it is an production server
September 22, 2009 at 2:07 am
all backups are vaild , it is an production server
September 22, 2009 at 2:11 am
Can you post the history of the job, so that we can see what you are saying
--------------------------------------------------------------------------------------
[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]
September 22, 2009 at 3:22 am
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message is
Message
[264] An attempt was made to send an email when no email session has been established
September 22, 2009 at 3:30 am
ramyours2003 (9/22/2009)
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message isMessage
[264] An attempt was made to send an email when no email session has been established
Sounds like you have emil notification set up, is this in a separate job step
--------------------------------------------------------------------------------------
[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]
September 22, 2009 at 3:35 am
ramyours2003 (9/22/2009)
email is not established , mail is not configured , how to resolve this .
Can you check
1) your backup script if at all it has some script which is trying to send email notification(s)? If this is not the case please check the below.
2) if in the SQL Server Agent Properties>Alert System>Enable Mail Profile option is checked.
3) In the job Properties, if there is any value set for Alerts or notification
September 22, 2009 at 3:40 am
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message is
Message
[264] An attempt was made to send an email when no email session has been established
September 22, 2009 at 3:41 am
ramyours2003 (9/22/2009)
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message isMessage
[264] An attempt was made to send an email when no email session has been established
Can you please check for what I have mentioned in my above post. I believe the problem is in there only. Lets see.
September 22, 2009 at 3:43 am
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message is
Message
[264] An attempt was made to send an email when no email session has been established
September 22, 2009 at 3:47 am
the backup files are updated in the disks showing the backups are successful but in the job history showing the failed status . The error message is
Message
[264] An attempt was made to send an email when no email session has been established
Viewing 15 posts - 1 through 15 (of 23 total)
You must be logged in to reply to this topic. Login to reply