June 5, 2014 at 9:40 am
I am using sql 2012 Interprize and replication
The data base I am trying to replicate from is being used all the time
So I built a test bed server cmc-a (publisher) and cmc-c
I am using test bed to use for testing
I backed up database from cmc-a and put it on server cmc-c then I
followed the instructions for p2p replication and at end I selected
In the gui
"I restored a backup of the original publication database, and the publication database was changed after the backup was taken"
When the process replication setup finished
I made a change to cmc-a (publisher) database
I get the following error from replication monitor
"Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'. (Source: MSSQLServer, Error number: 2812)"
So I ran the following sql script on server cmc-a to find the procedure
"SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME like '%sp_MSins_dbotextmsg_filed%'"
I get the following.
"sp_MSins_dbotextmsg_filed_content014368500850223599121"
I found the procedure
Does this procedure need to be on both databases ?
If not what could be my problem
June 5, 2014 at 12:54 pm
It will need to be in both databases, or at least some version of it. Remember that Peer to Peer replication is in effect a series of transactional replicactions, so both servers will act as publisher and subscriber at the same time.
June 5, 2014 at 5:02 pm
Thank You for replying
when i select no 1
The replication works for my test
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.
when i use no 2
2) I restored a backup of the original publication database and the publication database was changed after the backup was taken.
I get following when I enter some data into Publisher
"Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'. (Source: MSSQLServer, Error number: 2812)"
June 10, 2014 at 3:43 pm
jim.hoopes 56932 (6/5/2014)
Thank You for replyingwhen i select no 1
The replication works for my test
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.
when i use no 2
2) I restored a backup of the original publication database and the publication database was changed after the backup was taken.
I get following when I enter some data into Publisher
"Could not find stored procedure 'sp_MSins_dbotextmsg_unfiled294157413'. (Source: MSSQLServer, Error number: 2812)"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply