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:[EMAIL PROTECTED] Sent: 14. februar 2003 10:58 To: [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> on 02/13/2003 10:35:24 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] 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. **********************************************************************