April 18, 2008 at 8:10 am
Hi everyone,
hopefully this is an easy one.
I configured replication to see how it would work for the solution that I'm building, more to play and learn a bit than to actually use it. I quickly learned that replication can use quite a bit of space, so I've taken steps to remove it. I deleted the Local Publications from the server, and cleared out the subscriptions on the computers that were subscribed to it. This of course cleared up quite a bit of disk space by deleting all the snapshots, it also deleted all the jobs that have been keeping up these snapshots. However, the distribution database is still hanging around.
My question is, will i ruin anything by simply dropping this table?
Are there any other considerations that i should take into account while removing the distribution server or the distributor?
Thanks in advance.
Pete
April 18, 2008 at 8:27 am
If you right-click on the replication node in object explorer, you can generate a drop script that may help you determine if everything has been cleaned up.
April 18, 2008 at 9:35 am
OK,
I take it back. You cannot right click and delete any table in the "System Databases section of the Object Explorer. Therefore you cannot create a script that would drop it.
Anyone have any other thoughts?
Am I right in assuming that the distribution database isn't doing anything sitting there?
Thanks again.
April 18, 2008 at 10:53 am
you are just trying to get rid of the distribution database right?
open up object explorer, right click on the replication folder, and select 'disable publishing and distribution'
That will disable your server from being a publisher and remove itself as the distributor, which will also remove your distribution database.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
April 18, 2008 at 11:49 am
Perfect, thank you so much.
April 18, 2008 at 12:27 pm
glad I was able to help.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply