not able to clean subscription by sp_mergesubscription_cleanup?

Question

question

Bhuvans asked Jun 15, '11

not able to clean subscription by sp_mergesubscription_cleanup?

Hi i am using this proc at subscriber as sp_mergesubscription_cleanup 'xx.xxx.xxx.xxx (public IP)','pubDBNAME','PUBNAME' but this is not working when i use to delete like this sp_mergesubscription_cleanup 'sysname','pubDBNAME','PUBNAME' this is working how to make proc work with public ip regards bhuvan

sql sql-server-2008-r2 replication

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-06-15T22:21:12Z

Cyborg answered Jun 15, '11

As per my knowledge you cannot pass the IP Address to publisher parameter in sp_mergesubscription_cleanup, you can use the server name only.

3

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Bhuvans commented · Jun 15, 2011 at 11:51 PM

so how do i clean subscription when i am in VPN

0 ·

Bhuvans commented · Jun 15, 2011 at 11:52 PM

actually after the successfull replication i need to delete the subscription. i am doing this by VPN.. then how to delete this in subscriber in T-SQL or RMO or anything

0 ·

Cyborg commented · Jun 16, 2011 at 01:18 AM

I am not sure whether the following will work, but will not harm you by any way, so you can try this. Create a Alias name for the Public IP Server in SQL Server Configuration Manager and try to use that alias name in sp_mergesubscription_cleanup. Good luck :)

0 ·

question