• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 594
  • Last Modified:

Removing replication

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
TRACEYMARY
Asked:
TRACEYMARY
  • 3
2 Solutions
 
imran_fastCommented:
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
 
TRACEYMARYAuthor Commented:
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
 
imran_fastCommented:
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
 
imran_fastCommented:
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

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now