Summary
Replication is an exciting technology that will play an important part in many real-world solutions. As a Microsoft SQL Server DBA, you must fully understand how to correctly set up and administer replication and how to correctly use replication to benefit your company or organization.
Following are some of the important things to remember for SQL Server replication:
SQL Server replication is transaction based and follows a loose consistency data distribution model to a no consistency data model.
Replication uses a publisher/subscriber metaphor.
Subscribing databases can perform updates when using merge replication or Immediate Updating Subscribers.
SQL Server uses ODBC or OLE DB for replication.
A server can play multiple roles and be a ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
