Change Backup email confirmation subject
kleesman
Posts: 12
Does anyone know if there's a way to change the subject of the confirmation email message the SQL Backup can send. Right now I'm getting "SUCCESS - full backup [multiple databases] on 2/27/2006 12:09:09 AM"
I've got multiple servers, test and production, being backed up and some of them have overlapping databases, so it's tough to tell which server a given message is for. I'd like to just be able to scan the message subjects to see "SUCCESS - <ServerName> - full backup...." for each of my servers.
Thanks,
Kyle
I've got multiple servers, test and production, being backed up and some of them have overlapping databases, so it's tough to tell which server a given message is for. I'd like to just be able to scan the message subjects to see "SUCCESS - <ServerName> - full backup...." for each of my servers.
Thanks,
Kyle
Comments
I can't figure out a way to set this as an option as the email subject seems to be hard-coded. What may be a good idea is to change the email from address to the name of the server, ie: SQLBackup@PRODUCTION. Provided your SMTP relay doesn't check the sender's addreess this should server as a pretty good workaround.
Thanks for your suggestion. I was able to make that serve the purpose of distinguishing servers.
Kyle