We have interrupted a running SQL Monitor Environment due Backup recovery of one resource. The recovered Database was created before this resource was connected to the Monitor System. Under this Situation, you have a resource without monitor connectivity (missing monitor user object). The "repair" button in this situation is "grayed" out and you have no chance to repair this resource. Furtheron the only way to get rid of this resource is to select "another" resource, then restart the Monitor Server, reconnect to the Monitor Server and DON'T select the unavailable resource. Click on adminitrator, delete the resource. The resource will NOT disappear, until you restart the Monitor Server again. After a successfull remove of the resource, you can recreate it.

Are you able to Enabling the "repair" button.

asked 10 Nov '14, 06:29

Bernhard%20Thormann's gravatar image

Bernhard Tho...
16334
accept rate: 0%


Hi Bernhard, I think you are saying that a SQL Anywhere database with a resource in the SAMonitor needed to be recovered. You recovered the database for it and then the SAMonitor listed the resource status as unavailable. If the recovered database is missing the SAMonitor objects created in it when the resource is first added to the SAMonitor, it must be repaired. You need to stop the resource first, then the repair button becomes enabled.

The repair button is only enabled when the selected resource is not running and the resource type is SQL Anywhere.

permanent link

answered 12 Nov '14, 11:49

PaulTonizzo%20%20SA%20tools's gravatar image

PaulTonizzo ...
516310
accept rate: 31%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×30

question asked: 10 Nov '14, 06:29

question was seen: 616 times

last updated: 12 Nov '14, 11:49