Appendix

About

This section is included to assist the students to perform the activities in the book. It includes detailed steps that are to be performed by the students to achieve the objectives of the activities.

Lesson 1: Getting Started with SQL Server HA and DR

Activity 1: Troubleshooting Snapshot Replication

Solution:

To modify the publication, follow these steps:

  1. Connect to the Publisher instance and expand Replication | Local Publication. Select the WWI-Snapshot publication and select Properties:
    Figure 1.84: The Properties option
    Figure 1.84: The Properties option
  2. In the Publisher Properties window, select the pre-snapshot and post-snapshot scripts, as shown in ...

Get Professional SQL Server High Availability and Disaster Recovery now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.