May 22, 2017 at 12:05 pm
What is difference between Replication and Always On?
May 22, 2017 at 12:39 pm
Without going into too much detail on this, if you are referring to Sql Server Replication, for example, transactional or merge, etc., replication occurs at the field(s) level for the database and is configurable at the table level and it requires a more extensive set up, for example, a Publisher, Distributor, and Subscriber. Always On is more of a DR/HA option where one or more databases are kept in sync by applying transaction logs blocks at the database level and is very similar to Database Mirroring in Sql Server. With Always On, windows clustering is installed, and one or more databases can be placed in an Availability Group which can be failed over to a secondary server where all the databases in the particular availability group are failed over at the same time.
May 22, 2017 at 1:00 pm
The bigger question is why do you ask? What were you thinking of doing?
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply