If DBAs' wish lists for the new year have one item in common, it's more storage.
The survey also finds that Now, the analyst continued, DBAs are working more closely with administrators and managers from the storage side to make sure they get what they need when they need it. It's especially important that they communicate where available storage should be allocated first in case of a database disaster.
Luckily, storage professionals now have more tools at their disposal to help protect data in the event of a disaster. In addition to traditional tape backup, enterprises are utilizing new kinds of storage such as snapshot and virtual tape library (VTL) technology. These methods can help bring "30 hours of backup time down to a few minutes," Kaplan said.
"DBAs are being asked to keep more data around longer," Garrett said. "By proactively 'pruning' the database and archiving data, we can improve performance, backups, management and access to intellectual property." Archiving also decreases the time it takes to search and locate content within the database, he added.
A January 2006 research report conducted by Enterprise Strategy Group revealed that three out of 10 companies have already implemented some kind of database archiving application. Over half of large enterprises (with 20,000 employees or more) have deployed archiving.
Early adopters report benefits including speedier and less expensive backups, reduced time and cost related to disaster recovery, better database performance and easier storage management. Ultimately, Garrett said, the more control you have over your data, the easier it is to "keep your boss's name out of the headlines."
In 2005, unstructured data -- office documents, Web pages and image files, for example -- made up 82% of archived content, followed by email and database at 10% and 8%, respectively. The report concluded that structured content associated with database applications and email will grow more rapidly in the next five years than unstructured content, but unstructured content will continue to constitute the bulk of archived capacity.