BMCPatrol/BackupExec with MSDE and SQL Server Enterprise Edition

I have a odd situation and am unsure of my best option.
We use BMC Patrol to monitor an Enterprise Edition database. A server guy
came along and installed Backup Exec to make some one-off tape backups for a
vendor. He installed and decided to use MSDE. MSDE is now installed on my
server as well. I would never had known this except that BMC Patrol now has
no idea where my Enterprise Edition instance has gone to nor does it
recognize its existance.
BMC Patrol support bounced back the request for help by saying that MSDE has
"corrupted" registry settings and promoted itself somehow as the primary
instance in the registry.
Questions: Uninstalling MSDE did not resolve the situation.
- Is there such a registry setting?
- Is there a known, supported way to reverse this situation?
- Is my only alternative to re-install the SQL Server Enterprise Edition?
Thanks
hi Andy,
Andy Sprecher wrote:
> I have a odd situation and am unsure of my best option.
> We use BMC Patrol to monitor an Enterprise Edition database. A
> server guy came along and installed Backup Exec to make some one-off
> tape backups for a vendor. He installed and decided to use MSDE.
> MSDE is now installed on my server as well. I would never had known
> this except that BMC Patrol now has no idea where my Enterprise
> Edition instance has gone to nor does it recognize its existance.
> BMC Patrol support bounced back the request for help by saying that
> MSDE has "corrupted" registry settings and promoted itself somehow as
> the primary instance in the registry.
> Questions: Uninstalling MSDE did not resolve the situation.
> - Is there such a registry setting?
> - Is there a known, supported way to reverse this situation?
> - Is my only alternative to re-install the SQL Server Enterprise
> Edition?
I knew that installing MSDE sp3a on servers running SQL Server 2000 sp4 will
corrupt the registry in the
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\80\Tools\ClientSetup
SQLPath key
that's to say that breaks accessing Query Analyzer and SQL Profiler from
Enterprise manager, but this is the only problem I'm aware of.. BTW there's
no concept of "primary instance", just default and named instance, but
installing MSDE on a previously installed SQL Server (default or named
instance) server does not involve the reported scenario... this has been
tested for sure :D
I do not know which registry key is BMC Patrol tool querying on, and this
can be related to the reported corruption, but I really have no further
hints... I think you have to open a case with Microsoft PSS..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea Montanari wrote:
> I do not know which registry key is BMC Patrol tool querying on, and
> this can be related to the reported corruption, but I really have no
> further hints... I think you have to open a case with Microsoft PSS..
just an additional note... before calling Microsoft PSS, I'd check that your
Enterprise instance runs smoothly and as expected, that no errors are raised
(scan your log and event viewer) and I'd contact again BMC for the registry
key they thin are messed up...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.14.0 - DbaMgr ver 0.59.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Repli
cation Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.See if this helps:
http://msdn.microsoft.com/library/e...ltools_8o6r.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Replication Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.
See if this helps:
http://msdn.microsoft.com/library/en...tools_8o6r.asp
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

Blue shortcut arrow on Replication Monitor

What does a small blue arrow (like a file/folder shortcut) mean on the Replication Monitor? It
shows on Replication Monitor, Publishers, Agents and Distribution Agents.See if this helps:
http://msdn.microsoft.com/library/en-us/replsql/repltools_8o6r.asp
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Shawn Clabough" <shawnc@.uidaho.edu> wrote in message
news:OvtlRu2nFHA.2860@.TK2MSFTNGP15.phx.gbl...
> What does a small blue arrow (like a file/folder shortcut) mean on the
> Replication Monitor? It shows on Replication Monitor, Publishers, Agents
> and Distribution Agents.

blue return arrow icon on Replication monitor - significance?

Good morning,
This morning I opened up enterprise manager (sql Server 2000) and noticed a
blue return arrow looking icon on the Replication Monitor folder. When I
opened up Replication monitor I observed the same blue return arrow looking
icon on the publishers and agents folders. What is the significance of this
icon? How do I remove it?
When I get a red X icon I just restart the distribution agent and refresh
everythihg and the red x goes away. What do I need to do for this blue arrow
icon?
Thanks,
Rich
Rich,
do you mean the retrying icon? What is the message of the agent's history?
(I get this message when experiencing connectivity problems).
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Hi Paul,
Thank you for getting back to me on this. In the Agent History, the Last
action (11/28/06) says No Replicated Transactions are available. Is there a
site anywhere that explains what the various alert icons signify? This way I
can use the standardized lingo to describe what I am seeing.
It is still a little bit early over my way, and customers haven't been
calling about any problems (yet). Do I need to do anything or will this
resolve itself? We have, been having some connectivity problems in recent
times. But usually, I get a big red x when that happens. I restart the
Distribution Agent and it goes away.
"Paul Ibison" wrote:

> Rich,
> do you mean the retrying icon? What is the message of the agent's history?
> (I get this message when experiencing connectivity problems).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com .
>
>
|||Well, I just refreshed the replication monitor and the blue arrow Icon did in
fact go away. At least it wasn't a big red x.
"Rich" wrote:
[vbcol=seagreen]
> Hi Paul,
> Thank you for getting back to me on this. In the Agent History, the Last
> action (11/28/06) says No Replicated Transactions are available. Is there a
> site anywhere that explains what the various alert icons signify? This way I
> can use the standardized lingo to describe what I am seeing.
> It is still a little bit early over my way, and customers haven't been
> calling about any problems (yet). Do I need to do anything or will this
> resolve itself? We have, been having some connectivity problems in recent
> times. But usually, I get a big red x when that happens. I restart the
> Distribution Agent and it goes away.
>
> "Paul Ibison" wrote: