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
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 DirectorThe 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