Due to an outage, IME was re-created, and FWSERVICE_REQUEST was emptied after IME re-creation.'
What is the steps to restore FWSERVICE_REQUEST from earlier backup
Release : 12.6.4
Component : IdentityMinder(Identity Manager)
Database: MSSQL 2008
Due to outage that existing table entries has been removed.
Steps to Restore backup records to existing tables
1) Ensure there is no duplication between backup records and existing table by comparing the primary key UNIQUE_NAME field . If there is duplicate records, remove duplicate records
2) Run the following query to make sure primary key did not reference to other table
SCHEMA_NAME(schema_id)+'.'+[name] as objectname
,referenced_schema_name AS SchemaName
,referenced_entity_name AS TableName
,referenced_minor_name AS ColumnName
FROM [sys].[all_objects] ob cross apply sys.dm_sql_referenced_entities ( SCHEMA_NAME(schema_id)+'.'+[name], 'OBJECT') e
where is_ms_shipped = 0 and type_desc in ('AGGREGATE_FUNCTION'
and name !='sp_upgraddiagrams'
and referenced_entity_name = 'FWSERVICE_REQUEST'
and referenced_minor_name = 'UNIQUE_NAME'
3) With no other reference table, append the backup table with existing table
Please consult DBA for restoring DB process