Saturday, November 3, 2012

How To Remove a SQL Server Distribution Database

Recently I was ran into a situation that it couldn't remove the distribution database through sp_dropdistributor or graphical management studio. When I was trying to remove the distribution server its actually not throwing any error, it's keep on running for long time. Microsoft has a good KB article which shows how to do it. It's also not worked this time but earlier it worked with me.

Finally I got the solution, here is the simple fix for this error!!!



USE master 
Go 
Alter Database distribution Set Offline; 
GO
Drop Database distribution;
SQL Replication distribution database. Cannot drop the distribution database. How to move the distributor to another server. How To Configure Database Mirroring and Database Replication. Cannot drop the database because. Unable to remove Distribution database. Disable Publishing and Distribution (Replication Transaction). Cannot drop the distribution database. Accidentally Dropped the Distribution Database. delete distribution database sql server 2005. sql server 2008 delete distribution database. delete distribution database sql server 2012. sql server 2012 delete distribution database. Microsoft SQL Server: Remove Distribution Database. Why SQL Server doesn't allow to remove a Distributor exactly after. Issues dropping distribution database . How to delete distibution database in replication. How to manually remove a replication in SQL Server 2000. How to manually remove a replication in SQL Server 2008. How to manually remove a replication in SQL Server 2012.

0 comments:

Post a Comment