Video Screencast Help

Media list for MS SQL restore from client side gui

Created: 29 Jan 2013 • Updated: 16 Feb 2013 | 3 comments
This issue has been solved. See solution.

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.

Comments 3 CommentsJump to latest comment

RamNagalla's picture

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's picture

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

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

Marianne's picture

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


Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links