We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Medium Priority
1,683 Views
Last Modified: 2012-06-21
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
Comment
Watch Question

Rahul AgarwalTeam Leader
CERTIFIED EXPERT

Commented:
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 PatelSolution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT

Commented:
Using Context menu delete the subscription and create using wizard.

Author

Commented:
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
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Qlemo"Batchelor", Developer and EE Topic Advisor
CERTIFIED EXPERT
Top Expert 2015

Commented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.