asked on

Drop and Re-create Subscription on a server(P2P Replication)

I have a peer to peer transitional replication running on two servers. All of a sudden the subscriber on one of the servers went down with the following error.
How do I drop and recreate a subscription in MSSQL 2008?
error.png

Rahul Agarwal

To Drop Subscription on a server(P2P Replication) refer the link:

http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/363e5452-1a54-4207-9bcc-ff238012880c

To Re-create Subscription on a server(P2P Replication) refer the link:

http://msdn.microsoft.com/en-us/library/ms152536.aspx

Alpesh Patel

Using Context menu delete the subscription and create using wizard.

isaackhazi

ASKER

I cannot do that as it is a P2P trans replication.

I deleted it using the context menu but Im unable to add the subscription back...

So then I tried to add it thru a SP ..

use [PRTR_recruit_live]
exec sp_addsubscription @publication = N'PublicationPRTR', @subscriber = N'prtrescrmserver', @destination_db = N'PRTR_recruit_live', @sync_type = N'initialize from lsn'
GO

with the above I get an error saying @subscriptionlsn cannot be NULL...

Any ideas...

I seriously dont want to re-do the entire replication again. as the other server is at an off site location about 200 kms from here and the database size is 40 GB

ASKER CERTIFIED SOLUTION

isaackhazi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Qlemo

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.