Share via


SQL Script: Delete all CS and MV data

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;