Report/Alert on missing backups in last N days/hours

  • Select specific file to download:

    Download
  • Download Details

    Thumb
    • Author: Jennifer McCownJennifer McCown
      • 3uploads
      • 0questions
      • 0answers
    • Views: 462 Views
    • File size: 3.51 kB
    • Downloads: 17
    • Updated: Aug 17, 2016
    • Categories:
  • (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

    TopicPostsLast PosterUpdated
    No topics

    Please log in to post questions