Restore BODS Local Repository?
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 (18.104.22.1688)
Repository Database: DB2 V9
Daya Jha replied
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|
|1||All Project Information||Select * From ALVW_PROJECTINFO|
|2||All Jobs Information||Select * From ALVW_JOBINFO|
|3||All WorkFlow Informtion||Select * From ALVW_WORKFLOWINFO|
|4||All DataFlow Information||Select * From ALVW_DATAFLOWINFO|
|5||All DataStore Information||Select * From ALVW_DATASTOREINFO|
|6||All Function Information||Select * From ALVW_FUNCINFO|
|7||All File Format Information||Select * From ALVW_FILEFORMINFO|
|8||All Source Target Information||Select * From ALVW_MAPPING|
|9||All Jobs Execution History||Select * 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.