Good Afternoon,

        I am trying to identify the "best solution" for achieving long term
storage requirements.  However each option has pros and cons.  Would anyone
like to share their long-term storage solution and why they chose that way.
My storage requirement is 7 years.

        Here are the options I have come up with so far

Backup Sets:
        pros:   Can be placed on CD ( lower media cost and easier to store )
                Does not require addition client session

        cons:   A backup set can only be restored in it's entirety.
                How to create backup sets for databases backed up with
utilities like SQL-Backtrack or TDP?


Archiving:
        pros:   Possible to restore single files

        cons:   I don't think it is possible to archive to CD-Rom. ( Correct
me if I'm wrong )
                Cost of tape cartridges to hold 7 years worth of data
extremely expensive.
                Requires addition session with client


Additionally one benefit to a backup set would be that if in X years if the
TSM Server is replaced by another product only the TSM client would be
needed to restore a backup set.  Whereas to restore archived information the
TSM server would be required.

Thanks,
Jon Martin