September 6, 2009 at 11:41 pm
We have subscriber database Server and we don't know which kind of replication is configured on it. From Publisher we can get idea but from subscriber, how to i know that. Is there any way to know from subscriber server that which kind of replication is configured?
Shamshad Ali.
September 7, 2009 at 9:16 am
Go to your distribution server and examine the publication_type column in the table distribution.dbo.mspublications. Values are :
0 = transactional
1 = snapshot
2 = merge
Mike
September 7, 2009 at 11:09 pm
Mike,
I don't have access to Publisher and distributer server, we are only subscribers and don't know what kind of replication they configured to provide data.
By my guess i had created few triggers on replicated tables in our subscribed database tables, when are not present anymore. I guess when snapshot replication is configured it will drop tables and re-generate table and its data.
From this guess i can say they have configured snapshot replication. but i want a solid proof if there is any way to know by standing on subscriber server i can tell them you have setup snapshot replication and we need transactional replication so that any change comes from Publisher can be logged/monitored and based on that change we make changes in our local tables etc.
Hope you understand what i am trying to achieve? Please help
Shamshad Ali.
September 7, 2009 at 11:25 pm
Mike,
I don't have access to Publisher and distributer server, we are only subscribers and don't know what kind of replication they configured to provide data.
By my guess i had created few triggers on replicated tables in our subscribed database tables, when are not present anymore. I guess when snapshot replication is configured it will drop tables and re-generate table and its data.
From this guess i can say they have configured snapshot replication. but i want a solid proof if there is any way to know by standing on subscriber server i can tell them you have setup snapshot replication and we need transactional replication so that any change comes from Publisher can be logged/monitored and based on that change we make changes in our local tables etc.
Hope you understand what i am trying to achieve? Please help
Shamshad Ali.
September 9, 2009 at 4:55 am
Sorry for not replying sooner. I don't appear to have received a notification indicating that you had replied to my post. Mind you, knowing me I probably accidentally deleted it.
I can't think of a 100% certain way of telling what sort of replication is feeding your subscriber if you don't have access to the publisher. In your subscribing database there is a table msreplication_subscriptions which tracks all sorts of information about what the distribution agents are doing. One of the the columns, "time", tells you when the distribution agent last wrote to the subscriber database. I suppose if that is being regularly updated then it is unlikely that snapshot replication is being used.
Maybe you could use profiler to look for replication activity and try and guess from that.
Sorry not to be more helpful. I'll keep scratching my head.
Mike
September 14, 2009 at 1:59 am
It was so easy i can't imagine. From your subscriber server go on replication --> select local subscriptions and when you hover your mouse it will give you details about the subscription in tooltip. it will show you what kind of replication you are subscribed for.
I am sure this information coming from tool tip would be somewhere stored on local subscriber. but my problem was solved just to know about the replication type.
Shamshad Ali.
September 14, 2009 at 2:16 am
Ah, well spotted. I've seen all those appear but have never really read them too closely. That'll teach me!
Mike
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply