01-29-2013 08:04 AM
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.
Solved! Go to Solution.
01-29-2013 01:15 PM
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
01-29-2013 08:31 AM
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.
01-29-2013 09:10 AM
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
01-29-2013 01:15 PM
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