How can we help you today? How can we help you today?

Change Backup email confirmation subject

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
kleesman
0

Comments

2 comments

Sort by
  • Brian Donahue
    Hi Kyle,

    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.
    Brian Donahue
    0
  • kleesman
    Brian,

    Thanks for your suggestion. I was able to make that serve the purpose of distinguishing servers.

    Kyle
    kleesman
    0

Add comment

Please sign in to leave a comment.