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
Due to outage that existing table entries has been removed.
Release : 12.6.4
Component : IdentityMinder(Identity Manager)
Database: MSSQL 2008
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