"Launch Database Mirroring Monitor" is not an option

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

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

|||

Hi...

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

Thanks,

Forch

|||

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

|||

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

|||

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

|||

I just terminalled into the db server but alas, no Database Mirroring Monitor.

oh well....thanks anyway

ed

|||

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