On Tue, Oct 07, 2008 at 10:29:33AM -0400, brerrabbit wrote:
> Greetings
> 
> Does anyone know of a way to get a report of the nominal size of a
> saveset and the actual space consumed on media (where tape compression
> has been enabled)?

Nope.  While modern drives probably know that information, there's no
standard way of inspecting it easily.  So no commercial application that
I know of tries to grab it.

If you have a particular model drive, look at the user manual.  There's
often a scsi page that you can read that shows capacity or compression
information. 

> The reason I ask is that our SQL DBAs are eager to start encrypting
> their flat-file backups, and I'd like to investigate the impact on
> that on the amount of space they will consume.  I know it will be
> more, but I'd like to know just how much.

Do their backups go to a pool of their own?  If so, just read the
capacity of full tapes before and after.  You won't get an instant
reading, but you will notice if the full tape capacity is reduced.

If they're intermixed with other backups on tapes, then this isn't going
to be as useful.

-- 
Darren

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER