Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ray.ragan
Starting Member
13 Posts |
 Posted - 2008-01-29 : 14:10:00
|
| What would happen if I dropped the distribution db? I'm having problems configuring distribution and after searching, I found someone that claims they solved the same problem by dropping the distribution db. The resolution is the last post on this thread: http://www.ureader.com/msg/11563430.aspxIs this safe to do? There are currently no publications and the distribution server is not configured.Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-29 : 22:59:09
|
| You should remove replication completely instead then reconfigure it. |
 |
|
|
ray.ragan
Starting Member
13 Posts |
Posted - 2008-01-30 : 11:06:03
|
quote:
Originally posted by rmiao
You should remove replication completely instead then reconfigure it.
I would like to, however there is no replication active. And both the Distribution and Publication dialogs fail to load (i.e. I right click on the node and select "Configure Distribution" or "New Publication" and an hour glass appears, but nothing happens). |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2008-01-31 : 12:46:49
|
| Distribution database only appears if you have replication configured.If you have replication and wish to remove this thenMake sure you stop the subscribers, remove subsribers then remove publications then disable publication from database, this should then delete distribution db for you. |
|
|
|
CShaw
Yak Posting Veteran
65 Posts |
Posted - 2008-01-31 : 13:42:30
|
| Try to remove Publishing and the distribution database first by going to the replication folder.Chris Shawwww.SQLonCall.com |
|
|
|
|
|
|
Is Dropping Distribution db a Good idea?