NEED TO EXTRACT EPO 5.1 SERVER TASK TABLE FROM SQL

[simchako]

Hello ,

NEED TO EXTRACT EPO 5.1 SERVER TASK TABLE FROM SQL ,

Some how few months ago few of my server tasks were deleted .....

recovered the sql db from that time , but now need to export the correct tables in order to import the deleted task back to my production server ?

need help please it is urgent

[cdinet]

It is not supported to import data into the epo database like that.  There are also inter-related tables that have data regarding the tasks.  You can get a list of the tasks that were scheduled from the orionschedulertask table and recreate it new in epo. 

[simchako]

Hi cdinet ,

Since i work with Goverment i cant elaborate to much , but the configuration scenario of our EPO installation Avoid me the easy export Server Task XML ...

Since this tasks i need were deleted a while ago the only thing i can do is trying to restore the task from the DB i have restored to another SQL Server .

I Guess if i were a DBA my Life would be easy 🙂 but since i am not i need help from all of you , tx

[cdinet]

As stated, even if you were a DBA, we do not support exporting data from a backup and importing it into your production database.  Your other option is to set up maybe a temporary VM and restore epo from snapshot from your backup database.  Then you can export the server tasks and import them that way.