Database Maintenance Error: There is no identical index in source table <tableName_stg> for the index <indexName> in target table <targetTableName>

In the swdebugMaintenance.log (C:\ProgramData\SolarWinds\Logs\Orion), you will see the below errors: 

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 3.70s Finalize Maintenance - CiscoBuffers

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.CiscoBuffers_CS_stg' for the index 'IX_CiscoBuffers_CS_Detail_hist_NodeID_F36AE' in target table 'NetPerfMon.dbo.CiscoBuffers_CS_Detail_hist' . ALTER TABLE CiscoBuffers_CS_stg

SWITCH

TO CiscoBuffers_CS_Detail_hist PARTITION 782

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 7.14s Finalize Maintenance - CPULoad

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.CPULoad_CS_stg' for the index 'IX_CPULoad_CS_Detail_hist_NodeID_55F95' in target table 'NetPerfMon.dbo.CPULoad_CS_Detail_hist' . ALTER TABLE CPULoad_CS_stg

SWITCH

TO CPULoad_CS_Detail_hist PARTITION 783

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 32.05s Finalize Maintenance - CPUMultiLoad

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_AggregateData_part: dbm_AggregateTimeSerie_part: XACT_STATE=-1ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.CPUMultiLoad_CS_Hourly_stg' for the index 'IX_CPUMultiLoad_CS_Hourly_hist_NodeID_B9F4A' in target table 'NetPerfMon.dbo.CPUMultiLoad_CS_Hourly_hist' ., ALTER TABLE CPUMultiLoad_CS_Hourly_stg

SWITCH

TO CPUMultiLoad_CS_Hourly_hist PARTITION 32

Warning: Null value is eliminated by an aggregate or other SET operation.

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 170.38s Finalize Maintenance - InterfaceAvailability

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.InterfaceAvailability_CS_stg' for the index 'IX_InterfaceAvailability_CS_Detail_hist_InterfaceID_0C700' in target table 'NetPerfMon.dbo.InterfaceAvailability_CS_Detail_hist' . ALTER TABLE InterfaceAvailability_CS_stg

SWITCH

TO InterfaceAvailability_CS_Detail_hist PARTITION 774

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 407.86s Finalize Maintenance - InterfaceErrors

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.InterfaceErrors_CS_stg' for the index 'IX_InterfaceErrors_CS_Detail_hist_InterfaceID_NodeID_Timestamp_A256E' in target table 'NetPerfMon.dbo.InterfaceErrors_CS_Detail_hist' . ALTER TABLE InterfaceErrors_CS_stg

SWITCH

TO InterfaceErrors_CS_Detail_hist PARTITION 783

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 77.00s Finalize Maintenance - InterfaceTraffic

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.InterfaceTraffic_CS_stg' for the index 'Index_1' in target table 'NetPerfMon.dbo.InterfaceTraffic_CS_Detail_hist' . ALTER TABLE InterfaceTraffic_CS_stg

SWITCH

TO InterfaceTraffic_CS_Detail_hist PARTITION 943

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 2.37s Finalize Maintenance - LoadAverage

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.LoadAverage_CS_stg' for the index 'IX_LoadAverage_CS_Detail_hist_NodeID_A02FA' in target table 'NetPerfMon.dbo.LoadAverage_CS_Detail_hist' . ALTER TABLE LoadAverage_CS_stg

SWITCH

TO LoadAverage_CS_Detail_hist PARTITION 782

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 37.49s Finalize Maintenance - ResponseTime

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.ResponseTime_CS_stg' for the index 'IX_ResponseTime_CS_Detail_hist_NodeID_9218B' in target table 'NetPerfMon.dbo.ResponseTime_CS_Detail_hist' . ALTER TABLE ResponseTime_CS_stg

SWITCH

TO ResponseTime_CS_Detail_hist PARTITION 783

--------------------------------------------

2026-01-26 04:30:44,004 [1] ERROR SolarWinds.Data.DatabaseMaintenance.Reporter - [Failure] 5.68s Finalize Maintenance - VolumeUsage

Message:

--------------------------------------------

dbm_ExecuteMaintenance: dbm_Move2Partitioned: ALTER TABLE SWITCH statement failed. There is no identical index in source table 'NetPerfMon.dbo.VolumeUsage_CS_stg' for the index 'IX_VolumeUsage_CS_Detail_hist_NodeID_Timestamp_37103' in target table 'NetPerfMon.dbo.VolumeUsage_CS_Detail_hist' . ALTER TABLE VolumeUsage_CS_stg

SWITCH

TO VolumeUsage_CS_Detail_hist PARTITION 783

--------------------------------------------

Index <indexName> from <targetTableName> is not removed during Database Maintenance.

1. RDP to your SQL server where you hosted your SolarWinds databases
2. create a backup of your SolarWinds databases (main, NTA, and log and event)
3. Open SQL Server Management Studio (SSMS) on your computer or on the SolarWinds Platform SQL server.
4. Go to the SolarWinds main database.
5. Find the database table 'NetPerfMon.dbo.CiscoBuffers_CS_Detail_hist'
6. Expand the table and go to Indexes.
7. Find the Index 'IX_CiscoBuffers_CS_Detail_hist_NodeID_F36AE' and remove it.
8. Repeat steps 5, 6, and 7 for the tables and indexes below to be removed:
table 'NetPerfMon.dbo.CPULoad_CS_Detail_hist' > index 'IX_CPULoad_CS_Detail_hist_NodeID_55F95'
table 'NetPerfMon.dbo.CPUMultiLoad_CS_Hourly_hist' > index 'IX_CPUMultiLoad_CS_Hourly_hist_NodeID_B9F4A'
table 'NetPerfMon.dbo.InterfaceAvailability_CS_Detail_hist' > index 'IX_InterfaceAvailability_CS_Detail_hist_InterfaceID_0C700'
table 'NetPerfMon.dbo.InterfaceErrors_CS_Detail_hist' > index 'IX_InterfaceErrors_CS_Detail_hist_InterfaceID_NodeID_Timestamp_A256E'
table 'NetPerfMon.dbo.InterfaceTraffic_CS_Detail_hist' > index 'Index_1'
table 'NetPerfMon.dbo.LoadAverage_CS_Detail_hist' > index 'IX_LoadAverage_CS_Detail_hist_NodeID_A02FA'
table 'NetPerfMon.dbo.ResponseTime_CS_Detail_hist' > index 'IX_ResponseTime_CS_Detail_hist_NodeID_9218B'
table 'NetPerfMon.dbo.VolumeUsage_CS_Detail_hist'index 'IX_VolumeUsage_CS_Detail_hist_NodeID_Timestamp_37103' 

9. Run the Database Maintenance manually or wait for the scheduled database maintenance, scheduled daily at 2:15 AM (default) local server time. How to run the database maintenance manually in Orion environment
10. Once done, refresh the check on the Deployment Health tab for the Database Maintenance error and see if the error still persists or not.