Which four actions should you perform in sequence?

DRAG DROP

You administer two Microsoft SQL Server database servers named ProdSrv1 and ProdSrv2. Each server has a database named Orders.

You need to configure transactional replication from the OrderSummary table in the Orders database on ProdSrv1 to the OrderSummary table in the Orders database on ProdSrv2.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

View Answer

Answer:

Explanation:

Step 1: Configure ProdSrv1 as a Distributor.

Step 2: Configure ProdSrv1 as a Publisher.

Step 3: Configure a publication of the Order-Summary table on ProdSrv1.

Step 4: Create a subscription of the publication in the Orders database on ProdSrv1.