How to restore deleted table (incl. Relations etc) ...

[Zod]

Hi there,

accidentally a table has been deleted in DEV (please do not further comment on this ... hurts already ;-( ... ) and need to be restored from TEST System.

Using a full backup is no option currently. 

Just exporting the table via xml and importing it will not do the job .. 

How to get a fields and relations (i.e. ACLs) into an updateset quickly ... without adding each entry manually ... any idea?

Thank you!!

PS: its an extended cmdb_ci_service table ... 

[ryanlitwiller]

We have had the same thing happen a few years ago. We ran into the same issue with export/importing XML, and inevitably had restore from a backup.

I've since found the Add to Update Set Utility from the share to be pretty useful, this might help you in more easily capturing everything you need in an update set.

[Zod]

Thank you. We do have a less complex ui action to do the job and this does not seem to work.

But this one might ... it says: -To add a full table definition and all dependencies (fields, labels, choices, attributes, default formview, default listview), use from the Table or Dictionary 'collection' record

So now I'm still not getting what is to be done. I tried in my developer instance .. and when going to the system_dictionary of the table to be added to the US .. then just marking the "collection" entry and adding it via the UI action to the US?

It does add something, but this does not seem to be the whole table. 

PS: I manually created the UI action for the relevant table - just importing the downloaded xml did not work ...but this should not make any difference ... 

Any further idea?

Thank you!

[sachin_namjoshi]

you can clone your DEV instance from TEST instance to get all schema and object updates.

OR you can create HI incident to ask support to restore your DEV instance with last backup.

Regards,

Sachin

[Zod]

As I said ... Using a full backup is no option currently. 

Servicenow told me they can only do a full backup restore ;-( .. not a table ...