How can I tell which tapes will be needed for a particular restore?

This Wiki is brought to you by Backup Central, where you can find the Mr. Backup Blog, Forums, and a mailing list for each forum!
Backup FAQs	Service Providers	Backup Software	Backup Hardware	Backup Book Wiki	Free Stuff	Miscellaneous

If you are using the Java GUI, start the

restore, and click "Preview Media Required".

You can also perform the restore (either via the GUI or command line), and have messages written to a log file. The beginning of the log will contain a list of tapes needed for the restore.

Or you can avoid the GUI (and avoid having to kick off a restore) with the bpimagelist command.

Let's assume you want to restore from a backup of CLIENTA that happened on August 1st.

(these commands would be run on your NBU master server)

1. 1. 1. First you need to find the exact start time of the backup you want:

 nbumaster# bpimagelist -U -client CLIENTA -d 08/01/2001 -e /08/01/2001

 Backed Up         Expires       Files       KB  C  Sched Type   Class
 ----------------  ---------- -------- --------  -  ------------ ------------
 08/01/2001 05:05  08/15/2001   729846 52624096  N  Full Backup  CLIENTA_OS
 08/01/2001 02:05  11/02/2001    58233  5029312  N  Full Backup  CLIENTA_DATA

1. 1. 1. Next you use the -media flag to see what volume(s) were used for that backup:

 nbumaster# bpimagelist -media -U -client CLIENTA -d 08/01/2001 05:05 -e 08/01/2001 05:05

 Media ID   Last Written       Server
 --------   ----------------   ----------
 602595     08/01/2001 05:05   nbumaster
 603084     08/01/2001 05:05   nbumaster

poof!