Solved

Drop Distribution Database

Posted on 2011-09-12
7
440 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Improvement  ( Speed) 14 37
Can I skip a node in XML? 9 35
Cannot connect to SQL express 2008 R2 installed on Server 2016 5 21
Database Mail Profiles 1 22
Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 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