We have many of our SQL Servers where we take the backup locally on the server as well as over the network to other server in case of disaster.
Also, we have a process set that server support team takes those backups on drives for a defined time out to tapes.
Recently we had an issue where server went down and didn't had the backups on its alternative server and so needed to recover them from tape. Initially even from tape that could not be located, something was a miss for sure but we got it finally.
So instead of being dependent on other team, is there a way in SQL may be via script we can get a report or build something that confirms backups are going successfully onto the tape and when?
Please advise, if it can be achieved. Thanks!