Solved

Drop Distribution Database

Posted on 2011-09-12
7
429 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 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