Hello,
Somebody tries recover nodes, Application, Components, Volumes, Interfaces from Backup DB by SQL Mangment Studio?
For Example:
SELECT * INTO NodesData_recovery FROM [dbo].NodesData where NodeID='2729' or NodeID='2730'
SELECT * INTO NodesCustomProperties_recovery FROM [dbo].NodesCustomProperties where NodeID='2729' or NodeID='2730'
SELECT * INTO APM_Application_recovery FROM [dbo].APM_Application where NodeID='2729' or NodeID='2730'
SELECT * INTO APM_Component_Recovery FROM [dbo].APM_Component where [ApplicationID] IN (SELECT [ID] FROM [dbo].[APM_Application] where NodeID='2729' or NodeID='2730')
SELECT * INTO Volumes_Recovery FROM [dbo].[Volumes] where NodeID='2729' or NodeID='2730'
Then create from this tables Script.
And execute them on Solarwinds DB.
Previously remove "_recovery".