Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Help to Remove Replication

0 views
Skip to first unread message

Vad

unread,
Aug 25, 2008, 8:28:01 PM8/25/08
to
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

unread,
Aug 25, 2008, 8:31:00 PM8/25/08
to
Forgot to mention that I am talking about SQL 2005

Vad

unread,
Aug 27, 2008, 2:04:07 PM8/27/08
to
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

0 new messages