Solved

Drop Distribution Database

Posted on 2011-09-12
7
404 Views
Last Modified: 2012-05-12
Initially, I configured replication in our production environment, but it seems not to be working as expected, now I needed to drop the distribution database under the System Databases, but need to know the proper way to achieve my objective.  

Question:
    How do you drop distribution database under Systems Databases without an advance effect?
    There are alot of Alerts in SQL Server Agent alerts owned by replication. Do I also delete all of these alerts?

0
Comment
Question by:Favorable
  • 4
  • 3
7 Comments
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36525730
Here is a post where a SQL MVP goes through the step by step process starting with ensuring all the publishers and subscribers are cleaned up properly.

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/7c12242d-cc1f-4f23-92e1-b8cffd55a59e/
0
 

Author Comment

by:Favorable
ID: 36525839
Thanks!
0
 

Author Comment

by:Favorable
ID: 36525941
After I successfully drop the distribution database under system databases, I noticed repl_distribution in my Linked Servers and several alerts under Alerts.

As anybody experienced similar issue and what to do?
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 59

Expert Comment

by:Kevin Cross
ID: 36526061
Did you use the process outlined with:

exec sp_dropdistributiondb
And:
exec sp_dropdistributor @no_checks = 1, @ignore_distributor = 1

?
0
 

Author Comment

by:Favorable
ID: 36526181
The second execution says : Uninstalling the server as a Distributor, which really got me scared.
 I'm not sure if this will drop stop the Server?
0
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 36526214
It is for uninstalling the distributor ... I do not believe this stopped server.
http://msdn.microsoft.com/en-us/library/ms173516.aspx
0
 

Author Closing Comment

by:Favorable
ID: 36526253
It worked perfectly!!!
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Suggested Solutions

     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

16 Experts available now in Live!

Get 1:1 Help Now