[Top] [All Lists]

Re: monitor sql backups

Subject: Re: monitor sql backups
From: Joe Webb
Date: Mon, 22 May 2006 06:11:38 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
SSNS is probably a bit of an overkill for this scenario. 

I'd probably look at scheduling a simple little VBScript that checks
the date/time stamp on the backup files and emails it to you if
somethings amiss.

Try here:

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Thu, 18 May 2006 22:33:02 -0700, Scott
<[email protected]> wrote:

>I currently receive a notification if my sql backup fails through sql agent. 
>However, there is always an outside chance that the sql agent is not working 
>either in which case I have no notification if my backups fail.
>Perhaps one can easily write a command prompt code to monitor the dates on a 
>folder and send out an email if the dates for the backup files are not 
>current. I dont 
>know how to write such a code. If anyone uses this or any other method to 
>monitor their backups, please email the code at [email protected]

<Prev in Thread] Current Thread [Next in Thread>
  • Re: monitor sql backups, Joe Webb <=