Restore BODS Local Repository?

[Former Member]

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 (14.1.2.378)

Repository Database: DB2 V9

[DayaJha · Accepted solution]

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
S.No	Details	Query
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.

Thanks,

Daya

[Former Member · Accepted solution]

Thanks Daya,

We restored on the same database because I'm the only one working on the repository, but I understand its a good practice to restore to new database and retieve from there.

Thanks for the queries, ran them and verified the data and double checked the Project/ Job in Designer, everything is back to yesterday's point, now I just have to update yesterday's modifications.

[Former Member]

Prashanth Chinta  

, My friend ,

How did you verify the existence of backup's your Local Repository ?

I just had the same problem .. importing a Batch Job, about the same old Batch Job that has a lot of improvements .

[Former Member]

Depending on your database, if you have some sort of online back up, you can check when was the last snapshot taken, if not you can ask your DBA to tell the last backup timestamp.

Note:If other folks are working on the project and their repos are in same database with different shcemas, better create a new db and restore last backup to that new db/schema, so others work won't be interrupted.

[Former Member]

Thank you for feedback Prashanth Chinta

I'm lining up with my team of Database Administrators , on strategies Backup and Restore of databases containing repositories .

We are working with the bods attached to Sql Server 2008 R2 .

Thank you