August 7, 2011 at 7:04 pm
please assist what steps i need to take.
One my old server had been decommissioned and we have new one for that.since there is a backup job in the old and new one but we are getting failure alerts.what si the reason how to handle this? please assist on this by any one.
August 7, 2011 at 7:09 pm
Do you have jobs running (in sql agent)?
Do you have 3rd party app like backup exec?
Maybe posting the full error message (excluding server name and logins) would help us pinpoint the alert sender!
August 8, 2011 at 6:10 am
Maybe I'm a little slow, but remove the old server from your backup process. Unless there's something here you're not stating, that seems to be the answer.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 8, 2011 at 6:19 am
I'm with you Grant, but if you don't know what's maintaining that server, then how do you stop it?
August 8, 2011 at 6:35 am
right there with you too, bu what generated the error? Go there first. I don't know, there's got to be more to this question than first appears.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 8, 2011 at 2:57 pm
there is no error to post .
just we are getting the mail alerts from old server which has been decommisioned but we have checked the job on the new server which is running fine.only the proble i am facing is getting the alerts from old server. please assisst on this.
August 8, 2011 at 3:33 pm
this implies that your backup process is managed somewhere else. Where is that? Remember, we're not there and can't see what you see. What service is sending out the email?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 8, 2011 at 3:41 pm
What does "decommission" mean? there is no feature in SQL Server to do this, so if you perhaps just removed or set the databases to offline, then you might be getting failure messages. Or if you have changed something else, you still may have jobs running on the old server, which would produce errors.
August 9, 2011 at 7:20 pm
There are no job in old server but we are getting the alerts from dbmail or sqlmail. please assist on this.
August 9, 2011 at 7:26 pm
narasimhareddy.dba (8/9/2011)
There are no job in old server but we are getting the alerts from dbmail or sqlmail. please assist on this.
There should be a "From Address" on the mail. Can you use this to identify the sending server?
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
August 10, 2011 at 6:22 am
narasimhareddy.dba (8/9/2011)
There are no job in old server but we are getting the alerts from dbmail or sqlmail. please assist on this.
We're trying, but we're not there, so we can't see what you see. You have to try to give more information. How are your backups managed? Are they run from a central location or are they handled separately on each machine? Do you have some kind of monitoring in place that might be checking for failed backups? We don't know your set up, so without data, all we can do is guess.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 10, 2011 at 9:52 am
Grant is correct, you aren't giving enough information. Is there monitoring on the new server for backups? If so, how does that work? Perhaps they are the same.
It doesn't have to be the old server that is sending alerts. Many people use a third server that connects to either the file system on a SQL Server instance, or the msdb tables and checks for backups. You'll have to look around your environment to understand how it is set up.
August 10, 2011 at 4:23 pm
yes, we are getting the alerts from server xyz like
<xyz>backup job failed from XYZ server.
please asist how to aviod those alerts from XYZ server.
August 10, 2011 at 4:26 pm
Sure, send me the vpn access info along with XXX$ in my paypal account and I'll get that sorted out for you.
In the mean time we don't see your servers and you're no answering our questions so we cannot help.
August 10, 2011 at 4:35 pm
narasimhareddy.dba (8/10/2011)
yes, we are getting the alerts from server xyz like<xyz>backup job failed from XYZ server.
please asist how to aviod those alerts from XYZ server.
That message in no way requires that server XYZ is sending the message. Your coworker could send that message from Outlook if they had the account credentials.
Go spend some time tracking down how the alerts are setup for backup alerts. Or turn off server xyz and see if the alerts stop.
Viewing 15 posts - 1 through 15 (of 15 total)
You must be logged in to reply to this topic. Login to reply