SQL report for Backup Schedule details
Can someone provide me an MS-SQL query to output the Backup Schedule details? I'm looking for it to contain the following:
- Enabled/Disabled
- Every x days
- At x time
- WHo to notify when backup fails (email address)
- Backup type (database an/or File attachments)
- Backup Location
- Retain x amount of backups
This would be super helpful for a dashboard I an writing.
Thanks