Re: E-mail notification for offline backup Script

Home Forums Scripting General Scripting E-mail notification for offline backup Script Re: E-mail notification for offline backup Script


L4ndy
Member
#275776

Re: E-mail notification for offline backup Script

joeqwerty;162320 wrote:
Why not use SQL Server to do the backup, use Database Mail to send the notification, and set up an Operator to receive the notification?

Hi Joe,

That would’ve been my preferred weapon of choice too, but we are using SQL 2005 express and we schedule the backups. AFAIK the express version does not have the database mail function and it does not support scheduling of backups (not out of the box anyway).
The scripting method I use does work fine I just wanted to add the mail notification which any of the command line mailers mentioned looks like is fit for the job.