Well, If all your data is backed up under the same retention policy and all your data has the full 8 versions, then you could make a mathmatical stab at this, I doubt that this is he case. What I suggest is that you pick one client that is representative of all of the rest You could then try to use sql to extract info from the backups table like file name, number of versions, backup date and then try to tie it in with size information from the contents table. Personally though, I would just move your representative client into a policy domain with your new retention policy, make a note of the space your client is using "query occupancy nodename" run expiration, then run another query occupancy The difference between the two query occupancies multiplied by the number of clients should give you a reasoable estimate of the space you will gain. Also do not forget the database saving. Hope this hepls John
"Stanley, Jon" <[EMAIL PROTECTED]>@vm.marist.edu> on 10/31/2003 03:01:30 AM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Space reclaimation by changing retention policy Is there any way to quantify the amount of space that will be reclaimed via changing a retention policy and letting expiration run until it's done? For example, the current policy is 180 day/8 versions. If I change that to 30 days/3 versions, how much space would I gain? I'm sure it's quite substantial, but I need to be able to quantify it. Thanks! -Jon ********************************************************************** 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. **********************************************************************
