0 Replies Latest reply on Sep 7, 2016 6:29 AM by bardeev

    Recover Nodes From Backup DB by SQL Managment Studio

    bardeev

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