Monitor SQL server backups
Monitor SQL server backups
Is there a simple way to monitor SQL Server backups? We have serveral SQL servers and we are looking for HostMonitor to notify us if a SQL backup fails or stop running on a daily basis.
-
- Posts: 2832
- Joined: Tue May 16, 2006 4:41 am
- Contact:
I think, you may use Folder/File Availability test method.
http://www.ks-soft.net/hostmon.eng/mfra ... #fileexsts
If you need to check some files that are dynamically created and do not have static name (e.g. some logs that are created on daily basis and have different file name every day), you may enable "Translate macros" options. With this option enabled you may use special date macro variables in file name (e.g. database_name_%mm%_%dd%_%yyyy%.bak).
http://www.ks-soft.net/hostmon.eng/mfra ... htm#macros
Regards,
Max
http://www.ks-soft.net/hostmon.eng/mfra ... #fileexsts
If you need to check some files that are dynamically created and do not have static name (e.g. some logs that are created on daily basis and have different file name every day), you may enable "Translate macros" options. With this option enabled you may use special date macro variables in file name (e.g. database_name_%mm%_%dd%_%yyyy%.bak).
http://www.ks-soft.net/hostmon.eng/mfra ... htm#macros
Regards,
Max