Change Backup email confirmation subject

kleesmankleesman Posts: 12
edited February 27, 2006 1:15PM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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.
    · Share on Twitter
  • kleesmankleesman Posts: 12
    Brian,

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

    Kyle
    · Share on Twitter
Sign In or Register to comment.