Solved

Removing replication

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

828 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