[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 472
  • Last Modified:

Drop Distribution Database

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
Favorable
Asked:
Favorable
  • 4
  • 3
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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
 
FavorableAuthor Commented:
Thanks!
0
 
FavorableAuthor Commented:
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
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Kevin CrossChief Technology OfficerCommented:
Did you use the process outlined with:

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

?
0
 
FavorableAuthor Commented:
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
 
Kevin CrossChief Technology OfficerCommented:
It is for uninstalling the distributor ... I do not believe this stopped server.
http://msdn.microsoft.com/en-us/library/ms173516.aspx
0
 
FavorableAuthor Commented:
It worked perfectly!!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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