Media list for MS SQL restore from client side gui

[ch0t0rsy]

I'm a NBU admin, and the DBA does frequent SQL restores which I need to create tape lists for.

Does anyone know how I can facilitate this list?  In the past, I've just had to bring all the tapes for that client server back into the library from the last 6 months.  There has to be a better way.

[RamNagalla]

the better way is,

get the date range of Images that SQL DBA is looking for, 

and check the media ids of the backups in the date range for the client/policy  using the GUI-cagalog or form bpimagelist command.

and make sure that the tapes are avaliabe in netbackup for restore.

[Mark_Solutions]

You can also open the BAR GUI and find the backup (policy type being MS-SQL-Server) - select it and then use Actions - Preview Media

The dba will have the BAR GUI available on his SQL client so can also do this for himself - you just cannot restore the images that way but it is a quick way to identify the tapes involved

[Marianne · Accepted solution]

You can run this command on the master server:

bpimagelist -media -client <client-name> -d mm/dd/yyyy  -e mm/dd/yyyy -pt MS-SQL-Server -U

-d = start date
-e = end date