SQL Administrator Question:
Download Job Interview Questions and Answers PDF
Tell us what are the different Topologies in which Replication can be configured?
Answer:
Replication can be configured in any topology depending keeping in view of the complexity and the workload of the entire Replication. It can be any of the following:
☛ Publisher, Distributor, and Subscriber on the same SQL Instance.
☛ Publisher and Distributor on the same SQL Instance and Subscriber on a separate Instance.
☛ Publisher, Distributor, and Subscriber on individual SQL Instances.
☛ Publisher, Distributor, and Subscriber on the same SQL Instance.
☛ Publisher and Distributor on the same SQL Instance and Subscriber on a separate Instance.
☛ Publisher, Distributor, and Subscriber on individual SQL Instances.
Download SQL Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Do you know what is DCL? | Tell me what are the different Authentication modes in SQL Server and how can you change authentication mode? |