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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-29 : 08:44:31
|
| Robert writes "WINNT 4.O SP6a SQLSERVER 7.0 (no service packs as yet) Two nodes using publisher/distributor on one node. All subscriptions using merge/push publications.Question: I would like to remove all unused subscriptions and replications that have been orphaned in the past. Detail: There are entries in the sysmergepublications table for publications in the subscriber database that no longer exist. When I try to delete and add new publications for tables, SQL server complains that the tables are already being replicated. Before applying SP4 and any other patches. I have been requested to resolve this issue first. Requested actions for me... :) 1. Fix replication issues..(ie. remove all unused replicaton subscriptions and publications) 1a. Bring both nodes down for maintenance. 2. Delete old replications... 3. Apply SP4. 4. Re-create replications... 5. Bring everything back up... To minimize downtime for the nodes, I would like to verify that step 1 is possible,(and how to do it) before bring the nodes down for maintenance. I don't want to remove all replcations at once, if possible." |
|
|
M.E.
Aged Yak Warrior
539 Posts |
Posted - 2002-10-29 : 17:12:22
|
| I am very unsure how this situtation came to be. I thought there is no way to have a subscription without a publication. If you delete the publication it removes the subscription.. no?Is there a large number of subscriptions/publications there? I would almost delete all subscritpions and recreate all of them. -----------------------SQL isn't just a hobby, It's an addictionEdited by - m.e. on 10/29/2002 17:12:54 |
 |
|
|
|
|
|
Orphaned Replication Subscriptions