April 19, 2010 at 5:54 am
Can anyone please post me a solution asap.
Transactional Replication configured for 2 servers and databases, after 3hrs sync, i dropped replication manually using stored procedures.
schocked...
When i checked and compared the constraints on Publisher and subscriber, i found no constraint on a single table on Subscriber database. All constraints got dropped. I donno how they are dropped.
Is that the replication drops all the constraints, any tables are dropped?
Confused why the constraints or dropped and found many tables missing...
Please provide better understanding links or info on this. As am struggling from past 1 week to sort this.
Fast help is appreciated...
Please post your suggestions.
Cheers,
- Win.
" Have a great day "
April 19, 2010 at 10:12 am
Anyone faced thus type of issue...
Will replication manual drop also drops Constraints on Subscriber. Even i didnt faced earlier in past 2 yrs... This case is frustrating...
Anyone pls post a suggestion...
Cheers,
- Win.
" Have a great day "
April 19, 2010 at 10:30 pm
Anyone faced the issue. Any thoughts and suggestions, please post.
Cheers,
- Win.
" Have a great day "
June 17, 2011 at 11:23 am
Happened to me too. Is there a way where we need to explicitly mention that we want to replicate the constraints as well?
Any help appreciated.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply