Email Notification

jortizv

Hi I have the following problem, the log files are massive as my database is very big with thousands of databases, so when an error happens it just send this 50MB file over an email which as you would have guess it is impossible to transfer due to limitations is most email providers to 20MB or so.
In other backup applications I could disable attach error log and just send the email saying there was a failure.
is there anything I can do to stop it from sending me this large email???

any help would be appreciated.

J

petey

Could you please try a patched SQL Backup Agent service (version 6.4.0.1031)? I've added a MAILTO_NOLOG option, so that SQL Backup does not send the contents of the log in the e-mail e.g.

EXEC master..sqlbackup '-sql "BACKUP DATABASES AdventureWorks TO DISK = [<AUTO>] WITH MAILTO = [dba@yohz.com], MAILTO_NOLOG"'

You can download it from here:

ftp://support.red-gate.com/Patches/sql_ ... 0_1031.zip

That archive contains the SQL Backup Agent executable file (SQBCoreService.exe). To replace the existing service executable file, do the following:

- ensure that no SQL Backup processes are running
- stop the SQL Backup Agent service, or disable the cluster resource if on a cluster
- rename the existing executable file (SQBCoreService.exe) in the SQL Backup installation folder
- extract and place the patched executable file into the same folder
- restart the SQL Backup Agent service/cluster resource

Let me know if this works for you.

Please note that this is an unofficial workaround for now. It might or might not make it into the next official release.

jortizv

oh nice.. thank you...