September 7, 2013 at 12:30 pm
Hi
I'm using the below 2 stored procedures for Automate Monitoring SQL Server Error Logs with Email Alerts.
It works great but it is not sending email when there is an backup failure error in error log
For example, I can see the below error in error log but the script is unable to send this error information in email.. Please advise
Error: 3041, Severity: 16, State: 1.
2013-09-05 15:18:52.95 Backup BACKUP failed to complete the command BACKUP DATABASE admi. Check the backup application log for detailed messages.
September 9, 2013 at 12:14 am
I believe in the stored proc "SQL_ErrorLog_Alert" all the backup related messages are being filtered out.
You might want to alter the procedure to comment out this line and re-try
OR ProcessInfo = 'Backup' -- Deletes backup information
Prashant
Check out my blog at http://sqlactions.com
September 11, 2013 at 5:16 pm
If we comment out the below sql, then each and every database backup information will be logged, which we are not interested in.i.e
Log was backed up. Database: db1, creation date(time): 2013/08/29(11:04:10), first LSN: 36:1384:1, last LSN: 36:1384:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'Z:\Backups\db_Log20130911160015.trn'}). This is an informational message only. No user action is required.
OR ProcessInfo = 'Backup' -- Deletes backup information
please advise
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply