Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Script to find "Not Appendable (Full Media)" in BEDB

Created: 23 Nov 2012 • Updated: 12 Dec 2012 | 4 comments
This issue has been solved. See solution.

Hi,

Do anyone has the script to find out the "Not Appendable (Full Media)" from backup Exec 2010 "Devices" tab in console by quering to BEDB SQL database. The list of these full tapes from tape library need to be generated to send at offsite.

Thanks.

Ni3

Comments 4 CommentsJump to latest comment

AmolB's picture

Have you checked the Reports tab within BE console. You may try creating a custom report to find

Media which is not appendable. 

pkh's picture

I think you should not base your decision to move a tape off-site on whether it is is full or not.  It is almost impossible for a backup set to exactly fill a tape to the brim.  Usually when a tape is full, it means that a backup set has filled the tape and it spilled over to another tape.  By just shipping the full tape off-site, you would be breaking up this spanning backup set to two locations.  This will present a problem when you need to use this backup set.

It would be better to move tapes off-site based on backup sets, rather than whether a tape is full or not.  For example, if a weekly backup set needs to be kept off-site and it uses 1.5 tapes, then move both tapes off-site.  Don't just move the full tape off-site.

SOLUTION
goreni3's picture

Hi Amol,

I will check te reports tab within BE console for a custom report.