Deleting inactive SQL Instances

• 
  Hi PaulL,
  
  Thanks for posting on the Redgate forums.
  
  The instance will be removed when the purge settings delete all of the data from the SQL Monitor repository. 
  
  You can check your purge settings on Configuration>Purging.

  Dan B July 10, 2018 15:21

  - 0 +
• 
  Hi PaulL,
  
  Thanks for posting on the Redgate forums.
  
  The instance will be removed when the purge settings delete all of the data from the SQL Monitor repository. 
  
  You can check your purge settings on Configuration>Purging.

  Dan B July 10, 2018 15:30

  - 0 +
• 
  This is not working for me.  I removed an instance from one of my monitored servers over a month ago (which is what is set on the Purge settings - 1 month) and it is still there.  How can I remove it from the monitor?
  

  JPennAsembia August 17, 2018 15:50

  - 0 +
• 
  I think we've got a bug here, we're trying to pinpoint it.

  Russell D August 28, 2018 08:31

  - 0 +
• 
  Did you check the box Delete all existing data for these servers from the Data Repository when you removed the Monitored servers?

  cfendrick September 11, 2018 18:00

  - 0 +
• 
  it looks like the only way to get rid of an instance in SQL Monitor is if it exists as a single instance. this way the "Remove Servers" option is available. if its a multi-instance server , the remove server option is greyed out . ideally a "Remove Instance" option would be ideal.

  shingic June 12, 2019 12:52

  - 0 +
• 
  Do you mean remove a single server (from a cluster?), rather than [sql] instance?

  Russell D June 17, 2019 07:45

  - 0 +
• 
  This is still an issue. I had a cluster with 4 nodes in it. I removed 2 nodes because they were no longer needed. These 2 nodes are still showing up. I don't want to purge all data now, i just want to remove these servers from within Redgate SQL Monitoring.

  TeunvdBiggelaar October 15, 2021 09:12

  - 0 +
• 
  Same issue here, I removed a server from a cluster, and it is now just sitting there greyed out on the main overview.  The most irritating part is it still takes up a license that I cannot use on a real server.

  Frank_K November 24, 2021 13:21

  - 0 +
• 
  To resolve this issue do the following:
  
  First, take a backup of the data repository (RedGateMonitor database by default) in case anything should go awry.
  
  Then, we will need to find the entry for that instance in the repository in the settings.SqlServers table - which will look like:
  
  

  SELECT * FROM settings.SqlServers AS ss
  
  WHERE Name = 'FirstNodeName\' OR Name = 'SecondNodeName\';

  And then you would want to delete by Id the entry in that table that has name that matches the two nodes that no longer exist (which represents the default instance on that server, if it was a named instance it would have the instance name after the backslash e.g. serverName\instanceName)
  
  

  DELETE FROM settings.SqlServers
  
  WHERE Id = '<theIdFromFirstNodeAbove>' OR
  
  Id = '<theIdFromSecondNodeAbove>';

  
  This worked for me and was given as a solution by the support team in the past.
  Good luck!

  TeunvdBiggelaar November 26, 2021 08:51

  - 0 +
• 
  Thank you for the solution!  It worked perfectly for me.

  Frank_K November 29, 2021 16:49

  - 0 +

Add comment

Please sign in to leave a comment.