This will give you the filespace usage, which is the active backupset size
except it includes excluded data. It should be good enough for an estimate.

select node_name, cast(sum(capacity*pct_util/100) as decimal(10,3)) as "MB
of Used" from filespaces group by node_name

However, I am not sure how you are going to get this done.  Are you creating
these for faster recovery from the server or for standalone on a CD?  If it
is from the server, you may think about collocation by node.

Paul D. Seay, Jr.
Technical Specialist
Northrop Grumman Information Technology
757-688-8180


-----Original Message-----
From: Halvorsen Geirr Gulbrand [mailto:gehal AT WMDATA DOT COM]
Sent: Friday, February 14, 2003 5:02 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Estimating size of backup sets


I agree with John, this sounds very ambitious.
If you are only interested in active files, there is the possibility of
checking it on the actual client, how much data in each filespace
(filesystem/drive/etc). A worst case (it gives all backup-data, active and
inactive) could be "q occ t=b"

Rgds,
Geirr G. Halvorsen

-----Original Message-----
From: John Naylor [mailto:john.naylor AT SCOTTISH-SOUTHERN.CO DOT UK]
Sent: 14. februar 2003 10:58
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Estimating size of backup sets


Graham,
Your plan is extremely ambitious.
Is this a one off or are are you planning to do this regularly. How are you
goung to achieve this. Anyway you can get a reasonable idea from taking the
filepace occupancy, unless you have major excludes from backup, this is
going to be your active file size. John




Graham Trigge <graham_trigge AT enterpriseservices.com DOT au> on 02/13/2003
10:35:24 PM

Please respond to "ADSM: Dist Stor Manager" <adsm-l AT vm.marist DOT edu>

To:   adsm-l AT vm.marist DOT edu
cc:    (bcc: John Naylor/HAV/SSE)
Subject:  Estimating size of backup sets



TSMers,

Is there anyway people know of to estimate how large a backupset is going to
be? I have close to 700 nodes I want to generate backupsets for and I want
to know what sort of space I will be using up with them. I am assuming it
will be some sort of SQL statement looking at active files, but I can't
figure it out past that.

Any help would be appreciated.

Regards,

----------------------------------------------------------------------------
--

Graham Trigge
IT Technical Specialist
Server Support
Telstra Australia

Phone: (02) 9882 5831
Fax:      (02) 9882 5993
Mobile: 0409 654 434



----------------------------------------
The information contained in this e-mail and any attachments to it:
(a) may be confidential and if you are not the intended recipient, any
interference with, use, disclosure or copying of this material is
unauthorised and prohibited. If you have received this e-mail in error,
please delete it and notify the sender;
(b) may contain personal information of the sender as defined under the
Privacy Act 1988 (Cth).  Consent is hereby given to the recipient(s) to
collect, hold and use such information for any reasonable purpose in the
ordinary course of TES' business, such as responding to this email, or
forwarding or disclosing it to a third party.








**********************************************************************
The information in this E-Mail is confidential and may be legally
privileged. It may not represent the views of Scottish and Southern Energy
plc. It is intended solely for the addressees. Access to this E-Mail by
anyone else is unauthorised. If you are not the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be taken
in reliance on it, is prohibited and may be unlawful. Any unauthorised
recipient should advise the sender immediately of the error in transmission.

Scottish Hydro-Electric, Southern Electric, SWALEC and S+S
are trading names of the Scottish and Southern Energy Group.
**********************************************************************