Connection failed (Internal SQL Monitor error)

• 
  Hi, it's difficult to say without more information. If you click the gear icon and then select show log, what specific errors are you seeing?

  Russell D September 20, 2017 12:33

  - 0 +
• 
  Well, what I wrote under "The error:" is what you se when you show the log so I don't have more information about the error...
  
  
  
  //Mike
  

  raukroland September 20, 2017 12:38

  - 0 +
• 
  It's not a particularly helpful exception is it? .
  
  Can you email in the logs and I'll take a look to see if there's any more useful surrounding context.

  Russell D September 21, 2017 14:22

  - 0 +
• 

  Russell D wrote: »

  It's not a particularly helpful exception is it? .
  
  Can you email in the logs and I'll take a look to see if there's any more useful surrounding context.

  Sorry, I've been out of town for a couple of days, where do you want me to mail the logs?
  
  //Mike
  

  raukroland September 27, 2017 11:14

  - 0 +
• 
  Email them into support@red-gate.com.

  Russell D September 27, 2017 14:45

  - 0 +
• 

  I know I'm a littel late to the party but it my help somebody later

  It appears that the Redgate webserver or repository has trouble handling a large number of unfinished backup entries on the monitored servers.
  By querying the msdb database

  SELECT * FROM msdb.dbo.backupset WHERE backup_finish_date IS NULL;
  I foud that the affected servers had thousands of outdated(2024) entries with NULL values for backup_finish_date — one had over 15,000, another over 34,000.
  After updating these NULL values with the corresponding backup_start_date, Redgate was able to reconnect successfully, and the status turned green.

   

  Catalin November 10, 2025 07:05

  - 0 +

Add comment

Please sign in to leave a comment.