Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SAP Data Archiving

Former Member

on ‎2009 Feb 08 8:19 AM

0 Likes
396

Hi,

I need to archive some of the tables which are growing indefinitely ACCTIT, EDIDC.. etc.. we don't have any archiving solutions. If we archive the contents of this table can we access the contents of archive item at later time. Do we need to implement archiving solution.

Regards

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
Former Member
‎2009 Feb 10 6:51 PM
0 Likes

Hi James,

Missed some point, after implementing Archiving Solution you can retrieve data from SAP through standard transaction codes or some reports with slight modifications. We can also retrive the archived data from file system as well with same effort required for "Archiving Solution".

--Thanks

Pankaj.K.S

Show replies
Show replies
Former Member
‎2009 Feb 15 11:12 AM
0 Likes

Hi Pankaj,

Thanks for reply.. the archiving plan is not specific to the tables I mention. we want to use it as for every possile data we can offload from SAP database. Any generic notes reference of doc. kindly share.

Thanks.

JPReyes
Active Contributor
‎2009 Feb 15 5:47 PM
0 Likes

Let me explain something... Archiving should never be done to reduce the size of the database (this is just a consequence), is done to improve the performance of the system. Also its much more complex than just throw data into a external repository, as mentioned before this needs to be carefully planned to accomplish the best results achieving all legal requirements.

Thats my 2 cents

Regards

Juan

Former Member
‎2009 Feb 16 8:34 AM
0 Likes

Hi Juan

thanks.. we are planning to have archiving solution in place which can be use for both performance improvement and offloading data from database.

JPReyes
Active Contributor
‎2009 Feb 16 9:40 AM
0 Likes 
Do we need to implement archiving solution?.

You just answered to your own question

Former Member
‎2009 Feb 16 4:31 PM
0 Likes

Hi James,

In general there are no SAP notes to analyse the system database. We will have to analyse the system database completely and comeup with the largest tables from system and then need to identify archiving objects for those tables. also we need to make sure those are the valid archiving objects before implementing.

Also in parallel you also have to think of the archiving landscape, which is suitable for you.

Hope this helps.

--Thanks

Pankaj.K.S

Ask a Question