Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Unsupported: Use at your own risk
This script will delete all the records from FIM Sync database tables without affecting the MAs. It is useful when you have lots of MAs and export srvconfig/restore empty db/import srvconfig means painful enter of login data against all data sources.
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_connectorspace;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_cs_link;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_csmv_link;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_joiner_log;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_metaverse;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_metaverse_lineagedate;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_metaverse_lineageguid;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_metaverse_multivalue;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_mv_link;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_run_history;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_step_history;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_step_object_details;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_tracking_entries;
TRUNCATE TABLE FIMSynchronizationService.dbo.mms_tracking_entries_history;