Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Restore BODS Local Repository?

Hi All,

I accidentally replaced my Local repository with Central repo and lost 2 weeks of my work.

Is there any way I can restore my Local repository?

I checked the last backup of my Local repository database was this morning, if we restore database to that point, can I get my DS repository back to that point?

Any help is greatly appreciated, thanks.

Data Services Version : 4.1 (

Repository Database: DB2 V9

Former Member

Hi Prashanth,

Create a new schema and restore the Local repository backup, after restoring check the below table status for confirmation of correct backup that you have all the dependent objects or not like Project, Job, Work Flow, Data Flow..., before configuration in CMC.

Following are the List of Query to Fetch the Jobs Count
1All Project InformationSelect * From ALVW_PROJECTINFO
2All Jobs InformationSelect * From ALVW_JOBINFO
3All WorkFlow InformtionSelect * From ALVW_WORKFLOWINFO
4All DataFlow InformationSelect * From ALVW_DATAFLOWINFO
5All DataStore InformationSelect * From ALVW_DATASTOREINFO
6All Function InformationSelect * From ALVW_FUNCINFO
7All File Format InformationSelect * From ALVW_FILEFORMINFO
8All Source Target InformationSelect * From ALVW_MAPPING
9All Jobs Execution HistorySelect * From ALVW_HISTORY

With the help of above information you wlil know your backup is correct or not. and also check the Job Server Version status.



2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question