Solved

Drop Distribution Database

Posted on 2011-09-12
7
387 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
Comment Utility
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
Comment Utility
Thanks!
0
 

Author Comment

by:Favorable
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 59

Expert Comment

by:Kevin Cross
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
It worked perfectly!!!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

771 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

15 Experts available now in Live!

Get 1:1 Help Now