Solved

Removing replication

Posted on 2006-07-14
4
587 Views
Last Modified: 2012-06-27
i was using a third party to set up replication and my local server is in LOCAL not Name instanced
and i see this third party was just using sql replication.

I uninstall the s/w and im left with one database
DBRS_Distribution.
   I cannot drop this ....as has replication.

I have in Replication Monitor
  Publishers
      ASRCFHAPPDEV
             DBMoto_PUBTESTA:TESTA
In the Agents
           Snapshot
                  Publication                     Publisher               Published Database
                  DBMoto_PUBTESTA:      ASRCFHAPPDEV     TESTA


Im trying to remove all these...and having trouble.
i tried this
http://www.kbalertz.com/Feedback_324401.aspx

but could not get it to work.
0
Comment
Question by:TRACEYMARY
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 28

Accepted Solution

by:
imran_fast earned 500 total points
ID: 17113384
1.Remove all the subscribtion you have.
2.Remove all the publication you have.
3.Configure your server to disable replication.(right click on replication folder in the snapin)
4.Configure your replication to disable as distirbution server.
5.Drop database DBRS_Distribution
0
 
LVL 7

Author Comment

by:TRACEYMARY
ID: 17114039
I can 't do any of that in the EM as its a local server and not named get message cannot do replication on local...i was using 3rd party tool so they managed to add these replications to the SQL now im stuck with half it hanging around......

0
 
LVL 28

Expert Comment

by:imran_fast
ID: 17114058
What is the name of your local server? or ip address of your local server? if you worry about the password than create new user with sa privillages. register your sql server by name or ip using this user and drop the replication.
0
 
LVL 28

Assisted Solution

by:imran_fast
imran_fast earned 500 total points
ID: 17114062
also look into this

How To Disable Publishing and Distribution (Transact-SQL)
To disable a Distributor (Transact-SQL)

Execute sp_dropdistpublisher to drop a Publisher that is also the Distributor.


Execute sp_dropdistributiondb to delete the distribution database.


Execute sp_dropdistributor to remove the Distributor designation from the server.
To delete a distribution database (Transact-SQL)

Execute sp_dropdistributiondb to delete a distribution database.
To manually remove replication on a Publisher without connecting to the Distributor (Transact-SQL)

Execute sp_dropdistributor with @no_checks=1 and @ignore_distributor=1.
0

Featured Post

What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question