Friday, February 10, 2012

Can't get rid of distribution db

I have a separate server that is used as the distributor. We have our
production replication using a db called DistributorProd on this server
(this was built several weeks ago). I was doing some testing, so I created a
second db called DistributorTest on this server. After I was done testing, I
used the Wizard to remove the test replication. For some reason the
DistributorTest db is still there and I can't delete it. It says that it's
being used by replication. Any ideas on how to get rid of this? Is it
possible that my PROD replication is somehow now using both the
DistributorProd and DistributorTest dbs?
Thanks
On 2004-12-07, RML51 <mike.lacy@.courts.state.mn.us> wrote:
> I have a separate server that is used as the distributor. We have our
> production replication using a db called DistributorProd on this server
> (this was built several weeks ago). I was doing some testing, so I created a
> second db called DistributorTest on this server. After I was done testing, I
> used the Wizard to remove the test replication. For some reason the
> DistributorTest db is still there and I can't delete it. It says that it's
> being used by replication. Any ideas on how to get rid of this? Is it
> possible that my PROD replication is somehow now using both the
> DistributorProd and DistributorTest dbs?
>
I presume you tried 'stop publishing' wizzard from the Replication menu?
Mike
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr

No comments:

Post a Comment