How to confirm if the backups are going to tape in SQL Server 2005 and 2008 R2 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!
If you want to be sure that you're backups are going to tape, you need to periodically recall the tapes and restore the backups. We recall tapes once every three months to do this, it seems like a lot of effort but it is not overkill if you value having offsite backups.