Solved

Removing replication

Posted on 2006-07-14
4
581 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
  • 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

930 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now