Solved

Removing replication

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
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.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

813 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

10 Experts available now in Live!

Get 1:1 Help Now