Which tape hold a SQL DB Backup?
Hi all
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
- I would suggest:
1: Find the NBIMAGE id from MS SQL you want to restore.
2: Use bpflist command to find the netbackup image id, narrow down time frame as much as possible. Match the FN line from bpflist with the one you got from SQL server. This will give you the Netbackup image id.
3: Use bpimagelist to find the tapes (look for the line starting with FRAG, media id is field 8).
This the the non GUI way to do it ;-)
Regards
Nicolai