October 18, 2011 at 10:07 am
jared-709193 (10/18/2011)
EDIT: Maybe discussing the question on replication is important. My thoughts are that it is not performance that is the deciding factor on which type of replication to use, but what the use case is. We use Transactional Replication for replicating certain data from 4 production servers to our reporting server. The production servers are set up such that the application can write to any of the 4 servers, but always write to the "closest" as default. Other data is not replicated for reporting, but is replicated for failover. Since our company has decided against clusters and mirrors, we are using Transactional Replication with updatable subscriptions for these cases. I am relatively new to using replication (started with this company in April) and this seems to work fine for us. Any thoughts?Jared
Moving this to the end of the thread to start a relevant discussion 🙂
Jared
Jared
CE - Microsoft
October 19, 2011 at 1:58 am
SQLRNNR (10/18/2011)
nigel. (10/18/2011)
Sean Lange (10/18/2011)
... 😛...edited...
Nigel - could you also edit the quote since Sean edited his original comment and apologized?
Kudos to the respondents for cleaning it up:-)
Done!
October 19, 2011 at 2:00 am
Dev @ +91 973 913 6683 (10/18/2011)
Kudos to the respondents for cleaning it up
Not only cleaning it up but also to encourage new guys to come upfront as well. I know few of the forums where it’s not monitored and few experts use the language they should not.
I very much appreciate Steve’s intervention and then the cleanup from the guys (it shows their humbleness).
I am becoming a fan of SSC now. 🙂
Good! glad we've not put you off. :blush:
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply