locked
"Launch Database Mirroring Monitor" is not an option RRS feed

  • Question

  • Good morning all...

    I would like use the "Database Mirroring Monitor" to track what's going on.

    All three of my servers have SQL Server 2005 x64 edition installed with SP1.

    Server A is mirroring to Server C

    Server B is mirroring to Server C

    Following the instructions at http://msdn2.microsoft.com/en-us/library/ms365786(d=ide).aspx:

    On Server A and C, "Launch Database Mirroring Monitor" appears.

    On Server B, "Launch Database Mirroring Monitor" does NOT appear.

    Is there something I have to do to get this tool installed on the machine, or it is an automatic thing?

    Thanks!

    Forch

    Tuesday, May 16, 2006 12:55 PM

Answers

  • I have no idea why you can't see the Database Mirroring Monitor on your server.

    Go ahead and run "sqlmonitor.exe" from \tools\binn, and then select "go" and then "dbm monitor"

    That should at least allow you to get the monitor up and running.

    Thanks,

    Mark

    Thursday, May 18, 2006 9:57 PM

All replies

  • It is installed automatically.

    Here's my suggestion.  Are you sure that you have installed SP1 on machine B?

    I don't know what else to suggest. I'm following up with some of the testers.

    Thanks,

    Mark

    Tuesday, May 16, 2006 7:29 PM
  • Hi...

    Yes... SP1 was installed on all three machines.  The version displayed for all machines is 9.0.2047.

    Thanks,

    Forch

    Wednesday, May 17, 2006 12:25 PM
  • I have no idea why you can't see the Database Mirroring Monitor on your server.

    Go ahead and run "sqlmonitor.exe" from \tools\binn, and then select "go" and then "dbm monitor"

    That should at least allow you to get the monitor up and running.

    Thanks,

    Mark

    Thursday, May 18, 2006 9:57 PM
  • I came across this thread when looking for answers to exactly this question, but when I go run the sqlmonitor.exe mentioned in the previous post I just get a replication monitor up that doesn't give me any options to do anything...

    What am I missing?

    Thanks

    Ed

    Friday, December 8, 2006 12:42 PM
  • I suspect that by now you've figured this out but, in case it helps others....

    When I connect from a WS using SSMS to the instance of the server hosting the mirror I do not see Database Mirroring Monitor as described by others above.  However, if I TermServe into the server and connect to the instance using SSMS the option is there.

    As cool as mirroring is, it looks like it might still have a few rough edges.  Hope that helps.

    -D

    Thursday, January 18, 2007 6:53 PM
  • I just terminalled into the db server but alas, no Database Mirroring Monitor.

    oh well....thanks anyway

    ed

    Thursday, January 18, 2007 10:28 PM
  • What do you see when you look at the Primary in SSMS?  ...And the Partner?

    For me, I see:

    Primary:  TRACKIT(Principal, Synchronized)

    Partner:  TRACKIT(Mirror, Synchronized/Restoring...)

    Again, when I'm using SSMS from my WS and I right click the Primary=>Tasks  I see:

    -----------------

    Mirror...

    Ship Transaction Logs...

    ----------

     

    But when I TS into the actual DB server and right click the Primary=>Tasks I see:

    -----------------

    Mirror...

    Launch Database Mirroring Monitor...

    Ship Transaction Logs...

    ----------

    And like wow, I just realized that the server has spk1 and my WS doesn't....oops :)

    -Derik

    Thursday, January 18, 2007 11:35 PM