There are too many variables affecting the result. The best approach would
be to restore the database to a second instance, change the policy, let
the expiration run, ... and compare!

Zlatko Krastev
IT Consultant






"Stanley, Jon" <Jon.Stanley AT SAVVIS DOT NET>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
31.10.2003 05:01
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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