Archiving data

Marc,

Is there a software-based method for archiving seldom used data? The data cannot be purged, as we may need it for business or legal conformity reasons. We run both DB2 and Oracle databases.

    Requires Free Membership to View

    Login

    When you register for SearchStorage.com, you’ll also receive targeted emails from my team of award-winning editorial writers. Our goal is to keep you informed on the hottest topics, the latest news and the biggest challenges you face as a storage professional today.

    Rich Castagna, Editorial Director

    By submitting your registration information to SearchStorage.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchStorage.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

The word "archiving" has a number of different definitions. It sounds like you are looking for a way to maintain this data on off-line storage or on near-line storage.

The important thing is that you use the facilities included by the database vendor or by software vendors that specifically work with the database system and are certified by the DB vendor.

Options for databases include extract operations and exports. I would look for companies that provide database management software, not necessarily storage software.

Regards,
Marc

Editor's note: Do you agree with this expert's response? If you have more to share, post it in our Storage Networking discussion forum.

This was first published in March 2002