June 10, 2014 at 3:40 pm
I am using sql 2012 P2P replication
At the end of setup p2p replication
the last gui "New Peer Initialization" you have two choices 1 and 2
1) I created the peer database manually or i restored a backup of the original publication databases which has not been changed since the backup was taken.
2) I restored a backup of the original publication database and the publication database was changed after the backup was taken.
What does 1 mean and 2 mean
if I chose 1 the replication works for my test
if I chose 2 and do the following
Enter some data into Publisher
"Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'. (Source: MSSQLServer, Error number: 2812)"
Why does option 2 give me this error
June 11, 2014 at 12:29 am
Small bit of advice: you probably don't want to give two different questions the same topic name.
Now everyone thinks this question is a duplicate of your other replication question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 11, 2014 at 2:46 pm
Thank you for your help
This question is the same as the first one
I will be more careful when I use the Forum
I figured out what I was doing wrong
I removed the stored procedures when I configured the Publisher
This fixed my problem
I will use "Snap shots" for stored procedures
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply