July 22, 2015 at 11:02 pm
Comments posted to this topic are about the item SQL Server Replication
July 23, 2015 at 12:44 am
This was removed by the editor as SPAM
July 23, 2015 at 5:21 am
Thanks for a question that's outside my comfort zone.
July 23, 2015 at 6:53 am
Great question.
Not sure why so many people selected distribution agent and not log reader.
July 23, 2015 at 10:56 am
Replication often feels like a mysterious, black-magic operation that is too intimidating to understand. Your question highlights the fact that it is really just a bunch of tasks (agents) and transient data tables doing normal SQL stuff. The beauty is that they all dance together, usually in step with each other, but still just putting one foot in front of the other. It only LOOKS complicated; once you understand the functions of the various agents, not so complicated.
Good question.
Rob Schripsema
Propack, Inc.
July 23, 2015 at 12:12 pm
Very nice. Thanks, Vyas!
July 24, 2015 at 3:56 pm
Nice straightforward question.
For something over 6 years transactional replication (on sql 2000) was a critical component of disaster recovery for systems scattered around the world that I was responsible for. So I found this one easy, even now 6 years after I ceased to be involved with that (although I have looked to see any changes to transactional replication in new SQL Server releases). But questions about other sorts of replication than transactional would have me scrabbling for the documentation - merge replication seems to me like black magic.
Tom
July 28, 2015 at 7:26 am
Thanks for the question Vyas.
August 4, 2015 at 2:04 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 19, 2015 at 12:06 am
Refreshed replication knowledge
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply