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 |
|
gammax500
Starting Member
9 Posts |
 Posted - 2004-05-11 : 18:21:26
|
| We have a development server that has been crashing, and it looks as though the culprit MAY BE an incompletely removed replication distributor - right before the exception errors and datadump happens, we can see a call to the proc 'sp_MSrepl_startup'No subscriptions or publications exists, but in the replication monitor, the server shows up in the publications area, and there is a distribution database on the server holding all the MSarticles tables and so on. Since there are no existing publications and subscriptions, what additional steps can be taken to remove the server as a distribution agent?Thanks for any advice - |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-11 : 18:26:18
|
| Right click on the server in Enterprise Manager, go to properties. Then go to replication tab. Disable the distributor.Tara |
 |
|
|
gammax500
Starting Member
9 Posts |
Posted - 2004-05-11 : 19:12:43
|
quote:
Originally posted by tduggan
Right click on the server in Enterprise Manager, go to properties. Then go to replication tab. Disable the distributor.Tara
Well, unfortunately, that option is grayed out. As I mentioned, no publications/subscriptions show up in the replicaiton tab- but the server is show in the replication monitor and i see that the server is listed as a distributor in master..sysservers |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-11 : 19:20:17
|
| Can you rebuild SQL Server? The reason that I ask is that you are going to have to modify data in the system tables in order to fix this. It would be safer to rebuild it.Tara |
|
|
|
|
|
|
Incompletely removed replication distributor