Service Desk Practitioners Forum
cancel

How to retrieve the archieve data in HP SD 4.5

Highlighted
Jha kunal
Trusted Contributor.

How to retrieve the archieve data in HP SD 4.5

Hi All,
Can someone tell me 'How to retrieve the archieve data in HP SD 4.5'.
Or can i retrieve some specific data into Sd 4.5.
Any suggestion will be appreciated.
3 REPLIES
Mark O'Loughlin
Acclaimed Contributor.

Re: How to retrieve the archieve data in HP SD 4.5

Hi,

what are you looking to do. Please give more detail.
The Pike
Acclaimed Contributor.

Re: How to retrieve the archieve data in HP SD 4.5

The SD4.5 Admin guide reads:
...
When information is archived, it is copied to a predetermined archive location, and is then deleted from the production database.

The archived information is stored in XML format.

CAUTION
Archiving should not be used as a backup solution. Once information has been archived, it cannot be restored.
...

Basically, there is no SD functionality to restore the data once it's removed from the system.

However, since the information is stored in XML format, all you need to do is to extract it from the XML, make it readable to SD and re-import it back using Data Exchange (if I remember correctly, the Archive XML format is not compatible with Data Exchange XML format).

Also, look for workarounds discussed in previous posts...

Restore Archived Records in XML to Database:
http://forums13.itrc.hp.com/service/forums/questionanswer.do?threadId=269506

Points welcome!

The Pike
Venkatesha_1
Outstanding Contributor.

Re: How to retrieve the archieve data in HP SD 4.5

Hi,

As it is already mentioned that there is no straight step for restoring the archived data.

The data will be archived into XML format for the pre-defined set of columns.

If the column was not selected during archiving, then you can not restore back.

Also not sure how it handles when there is a relation between the modules[Like Service Call related to Change].

Be cautious about archiving.

Regards
Venky