• Select specific files to download:

  • Download Info

    Thumb
    • Author: Jennifer McCown
      • 9uploads
      • 0questions
      • 0answers
    • Views: 2263
    • File size: 3.51 kB
    • Downloads: 49
    • Updated: August 17, 2016
    • Categories:
  • Report/Alert on missing backups in last N days/hours

    (0)
    « »

    The function returns a list of databases that do not have an (undeleted) backup of type @BackupType within the last @BackupThresholdDays days (or alternately, within the last @BackupThresholdHours hours). See the code for limits and more documentation

     

    The job uses the function to send alerts as needed.  By default, it sends an alert if:

    • Any database does not have a full backup < 7 days old
    • Any FULL database does not have a log backup < 1 hour old

    See the code for limits and more documentation.

    Run the FN script in the database that houses Minion Backup.

    Run the job script in MSDB, after making modifications as needed (e.g., profile name, target email, etc.)

    8/17/2016 1.0

    Topic Posts Last Poster Updated
    No topics

    Please log in to post questions