Hello All,
Our Transaction log backup get pending sometimes due to broken chain, then IT converts itself to the FULL backup and It effects our systems during day. Is there a way to kill or suspend job when transaction log backup Converts to FULL? or is there a way kill/suspend when backup job gets pending?