cancel
Showing results for 
Search instead for 
Did you mean: 

Restore deleted querys in BW systems

Former Member
0 Kudos

Hi We have deleted the some queries accidenly in our bW systems, is there any way to restore back all bw queries.

This is very urgent

Regards,

Anbu

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear Anbu,

       In BI, for recovering the deleted queries is only possible, we have to re-collect the query

for Dev to prod.  We donot have any instant recover from production.  

Again we want to recollet the particular query from Dev, and SE09 release it and STMS_IMPORT in production server.  This is the way...

And keep it mind one thing, before deleting the query what ever you did on your deleted query           ( calculation and formulas ) it will not reflect the new recovered query.  You have to do the fresh job.

Regards,

Baskaran.

Former Member
0 Kudos

In which server this happened ?  and as others asked do u have any backup taken by basis?

If so u can restore it back to that particular date.

In worst case if two target has same structure , try copying of queries using RSZC.

Regards,

Venkatesh Babu

Former Member
0 Kudos
Hi Anbu,
There is no concept like restoring deleted objects from Dev point of view.
If you want the same quires again you need to re transport from Development.

Regards

Jagan 
Former Member
0 Kudos

jagan,

take help from basis team. they have back up of server in form of tapes.

former_member182470
Active Contributor
0 Kudos

Hi,

If you have accidentally delete Queries from your Dev or Qua, you can very well transport back your Queries from Prod.

or

If you have deleted from Prod itself, you can again transport from Dev to Prod.

Regards,

Suman

Former Member
0 Kudos

If a daily backup is in place, restoring from back up might be the only option.

- Hiri