Database Archiving Best Practices: Advice from the Trenches
September 1, 2004[From Enterprise IT Planet]
Data is growing at a rate of 125 percent a year. And a laundry list of regulations such as Sarbanes-Oxley, SEC 17a and HIPAA make it necessary to hold onto just about all of it. Yet according to Meta Group (Stamford, CT), up to 80 percent of this data remains inactive in production systems, where it causes countless problems.
Apart from the obvious ones such crippling performance and running out of disk space, companies report such problems as: entire system outages as the database requires too much processing; backup failures as there is too much data to backup in the available window; and transactions timing out as they have to search through millions of records.
The article continues at http://www.enterpriseitplanet.com/storage/features/article.php/3401301