Does anyone know how to find out which tape an SQL database is sitting on without actually starting up a restore?
For some reason I can't find an easier way to determine this.
1. If you look BAR console on the master server you can't check what tape is used or determine what the backup id is. This only contains a date/time-type stamp in the backup name and select the check media icon doesn't tell which tapes it resides on.
2. If you use the SQL interface on the client, it only shows the same date/time-type stamp for the selected database (same date/time as the BAR console)
3. If you run a bpimagelist you can filter the backup id's for the host but can't link it up to a specific database.
4. If you run the catalog utility in the NetBackup Console, you can do the same as bpimagelist but you also can't link the backups to databases.
It seems a little archaic to have to start a restore job then check the logs to find out which tapes are requested.
Thanks in advanced
Solved! Go to Solution.