Hi everyone,
I am looking for the script to take the backup of only failed backup jobs
example
i have database like test,test1,test2...etc
our backup plan is for these databases daily once full backup,for 6 hours differential ,every half an hour t log.
Howeverly, there is no guarantee backup will be successful all the time.
let's say backup job failed for test3 database,I can manually take backup of failed database but i have around 230 databases are running on my server.
daily atleast 20-50 backup jobs are failing i am taking backup manually.
it's to difficult for me to take each backup individually so i am looking for script to take the backup of only failed backup jobs if i check for tlog script has to take backup of all failed tlog jobs failed latest one.
Your help will be highly appreciable
Regards,
Harish.G