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 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.

Start your free trial