Data Archiving is a process of offloading the unused/inactive/dormant data from the online database and store it in an alternate storage system, such as magnetic tapes or hard disks. Archiving has many advantages like performance improvement, availability of storage space, reduced maintanenve costs, etc. Though, archiving has advantages, organizations cannot archive as they please. An organization needs to have data on the database to a certain period of time before it is archived in order to meet some legal and government requirements.
The archived data can be made available upon request. In order to make the archived data available it has to be re-loaded in to the online database. But, with NetWeaver 2004s, a new method of archiving called NearLine Storage has come into existence. A NearLine Storage acts as an intermediate solution between a traditional archiving and an online database. Using a NearLine Storage would allow us to have access to the archived data without the need of reloading the data to online database.
Archiving data process can be created using the context menu on the infoprovider we choose to archive. In the archive data process we define the fields from the infoprovider which are used for data selections, structure of the Archive file, archive file location, etc. Once thearchive data process is set up, we can start the archive process using the transaction SARA. It is possible to write the archive file and delete the archived data from database in two separate steps or it can be done in one single step by using an option while defining the archive data process. Using the logs and statistics from transaction SARA a detailed information about the archiving session can be obtained.