I have a problem with dropping connection to corrupted database in replication server 12.
What has happened:
I have db server "data_server1" with database named "dbstat" which have a dead connection in replication server. Database was deleted and there's no chance to recover it so I'm trying to drop this dead connection with standard command:
drop connection to data_server1.dbstat
when executing this command RS returned the following message:
"Database 'data_server1.dbstat' has subscriptions in it. Cannot drop connection to it."
so in next step i tried to drop subscriptions for this not existing anymore database:
drop subscription S3A_S2A_msg_xsd_slow
with replicate at data_server1.dbstat
and the RS returned following information about dropping:
I. 2011/03/08 10:47:31. REPLICATE Replication Server: Dropping subscription <S3A_S2A_msg_xsd_slow> for replication definition <S2A_msg_xsd_slow> with replicate at <data_server1.dbstat>
I. 2011/03/08 10:47:33. PRIMARY Replication Server: Dropping subscription <S3A_S2A_msg_xsd_slow> for replication definition <S2A_msg_xsd_slow> with replicate at <data_server1.dbstat>
but it cannot be dropped because of dead connection and no way to communicate with unexisting database.
Any idea how to handle with this problem?
How to force dropping subscriptions and dead connection?
Quick, clean & simply way to force drop connection DSI sybase replication server
I was in the same situation.
I was very embarrassed to drop a connection because of database replication definition subscription and a huge replication flow to skip.
Here is a quick, clean & simply way to force drop connection DSI sybase replication server :
1) resume connection to DS.DB skip to resync marker
2) wait & see for purge of RS queue (fast)
when queue is purged
3) suspend connection to DS.DB
4) in the same "go" :
resume connection to DS.DB (not with skip to resync marker)
drop subscription .. for database replication definition .. with primary at $LCONN with replicate at DS.DB
5) drop connection to DS.DB
I want to re-synchronize the replication server.
I have already stop the replication agent and truncate the secondary point to stop data transfer from and to the replication server.
when i attempt to drop the the connection the error encountered
Database "DBserver.DbName" is the primary for some replication definition. Cannot drop connection on it.
The replication settings is bi-directional, so i assumed that before dropping the connection, i have to drop the subscription first.
so I access the REP_SERVER_RSSD and enter the rs_help
Replication Definition Name
PRS Primary DS.DB Primary Table Replicate Table Type rs_classes