How do I monitor mirroring?

Chris,
There is an entire section named 'Monitoring Database Mirroring' on BOL
April 2006. Take a look at it.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:

> SQL2K5 SP1.
> I set up mirroring and the target DB now says (Mirror, Synchronized /
> Restoring) but it would seem as though there should be a way for monitor a
s
> well? To make sure its staying in synch, doesnt fail, etc?
> TIA, ChrisR
>
>SQL2K5 SP1.
I set up mirroring and the target DB now says (Mirror, Synchronized /
Restoring) but it would seem as though there should be a way for monitor as
well? To make sure its staying in synch, doesnt fail, etc?
TIA, ChrisR|||Chris,
There is an entire section named 'Monitoring Database Mirroring' on BOL
April 2006. Take a look at it.
Ben Nevarez, MCDBA, OCP
Database Administrator
"ChrisR" wrote:

> SQL2K5 SP1.
> I set up mirroring and the target DB now says (Mirror, Synchronized /
> Restoring) but it would seem as though there should be a way for monitor a
s
> well? To make sure its staying in synch, doesnt fail, etc?
> TIA, ChrisR
>
>

How do I drop a restored database named "distribution?"

I restored a backup of a replication database named "distribution" to a non-replicated development instance (ss2000). Well, when I try to drop the database I am told I can not because it is used for replication. It isn't. But you now how Microsoft is . . . . So the question is: how do I drop the database without rebuilding the server, or jumping through firery hoops?

Thanks!

Scorched

First do this you bonehead!!

sp_configure 'allow updates', 1 GO RECONFIGURE WITH OVERRIDE GO

Then you can update the sysdatabases.category = 0

Drop away!

How do I disable Named Pipes in SQL 7?

Hi All
I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
Named Pipes is ticked, but greyed out in the server
network utility. I only want to use TCP/IP. Does SQL 7
require Named Pipes? Can you not remove it?
Thanks
HH wrote:
> Hi All
> I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
> Named Pipes is ticked, but greyed out in the server
> network utility. I only want to use TCP/IP. Does SQL 7
> require Named Pipes? Can you not remove it?
> Thanks
> H
I believe SQL 7 uses Named Pipes connections for some internal
processing or possibly with tools on the server like SQL EM. You can
remove the protocol from clients. You might be able to change the
default pipe name on the server so clients have a harder time
accidentally connecting using named pipes.
--
David Gugick
Imceda Software
www.imceda.com

How do I disable Named Pipes in SQL 7?

Hi All
I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
Named Pipes is ticked, but greyed out in the server
network utility. I only want to use TCP/IP. Does SQL 7
require Named Pipes? Can you not remove it?
Thanks
H
H wrote:
> Hi All
> I've installed SQL 7 to 7.00.1094 (SP4 + MS03-031).\
> Named Pipes is ticked, but greyed out in the server
> network utility. I only want to use TCP/IP. Does SQL 7
> require Named Pipes? Can you not remove it?
> Thanks
> H
I believe SQL 7 uses Named Pipes connections for some internal
processing or possibly with tools on the server like SQL EM. You can
remove the protocol from clients. You might be able to change the
default pipe name on the server so clients have a harder time
accidentally connecting using named pipes.
David Gugick
Imceda Software
www.imceda.com