This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Recover Nodes From Backup DB by SQL Managment Studio

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".