Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Replication / August 2008

Tip: Looking for answers? Try searching our database.

Help to Remove Replication

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Vad - 26 Aug 2008 01:28 GMT
Distribution database files were lost because of the disk failure.

We decided to remove completely replication from the server.
I used exec sp_dropdistributor, sp_dropdistributiondb, sp_removedbreplication
I also run delete msdb..msdistributiondbs

After all, I do not have any records in
select * from master..sysservers WHERE srvname = 'repl_distributor'
Also GUI shows that I do not have distributor and Replication configured
(but does not give me to reuse existing Distribution DB name if I would
decide to reistablish replication)

The Distribution database is still present (without files) and if I do
select * from sys.databases , I can see distribution database has value "1"
in column "is_distributor". Because of it I can not just drop the
distribution database.

What can I do to remove distribution database?

Thank you
Vad
Vad - 26 Aug 2008 01:31 GMT
Forgot to mention that I am talking about SQL 2005

> Distribution database files were lost because of the disk failure.
>
[quoted text clipped - 17 lines]
> Thank you
> Vad
Vad - 27 Aug 2008 19:04 GMT
Paied to MS to get this done:

Use master

Alter DATABASE distribution SET OFFLINE

DROP Database distribution

They actually brought first the database online by using mdb file from dummy
database. May be this step not nessasary

> Forgot to mention that I am talking about SQL 2005
>
[quoted text clipped - 19 lines]
> > Thank you
> > Vad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.