How to completly stop mirroring, eg disable the endpoints on the server

We have tested mirroring with success.

Now we want to completly disable mirroring, and have done this on all mirrored database.

It seems though that the server stille maintains the mirror endpoints, hence you can do a "telnet localhost 5022".

How can we disable the mirroring endpoints ?

Martin Tan

SQL DBA

You would need to issue a drop endpoint statement for each of them.

how to completly remove all sql instances!

Hi there,

I kinda play with MSDE / SQL Express and now I need to remove everything!

I did the manual remove (http://support.microsoft.com/kb/320873/EN-US/)
but I did copy the osql.exe file.

Now, when I do osql -L to list the instances, I got 4 of them!
all of which I have no idea how they got there.. and the names tell me nothing (nothing I ever typed during my test!)

- JUKELANSRV\SQLEXPRESS
- QUAD-1800
- SERVEURSQL (that's in French!)
- VIVENDI

the only thing that MIGHT have cause SOME of these (certainly not all), is ENSIM X PRO

Anyway.. I need to remove them all and everything related to SQL.

Thanks for any response!Any thoughts on this?|||Himartinbl, as I understand the osql -L command is used to list all servers detected on the network, including SQL aliases created on local client. If you want to check installed SQL instances on you local machine, you can check in registry or services.msc

How to completely remove MSDE

I need to completly remove MSDE from my PC it was installed using Install Shield Express and when I try to uninstall, I get a Fatal error durring installation. There must be a way other than reformatting?

Thank you,If you can tell me what the error said, then I'll be in a position to help you. But If it said something about some file not be able to be deleted, make sure it (MSDE) isn't running.