Unable to drop connection to the Database

[Former Member]

Hello,

I have rep server like below

A-->RP01-->RP02-->B

A-->primary ase

RP01-->primary rep server

RP02-->Replicate rep server

B-->Replicate ASE server

Now i have shutdown B and forgot delete B's information from RP02 and later build new server C in place of B

Now when i am trying to drop connection of B its not getting dropped as B is no mmore there

Any forcefull ways to remove B's information from the rep server

Thanks

[jong-un_seo]

Hi,

How did you try to drop the connection?
If you want to remove B server and its databases,
try to use sysadmin dropdb command in ID server.
Normally primary RS will be ID server.

sysadmin dropdb, B, <database name>
go

Thanks,
Jongun Seo

[jong-un_seo]

For more detail of sysadmin dropdb,
please refer to click sysadmin dropdb.