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
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]
||[Next in Thread>|
- Re: monitor sql backups,
Joe Webb <=