Skip to Main Content
Professional SQL Server High Availability and Disaster Recovery
book

Professional SQL Server High Availability and Disaster Recovery

by Ahmad Osama
January 2019
Intermediate to advanced content levelIntermediate to advanced
564 pages
9h 2m
English
Packt Publishing
Content preview from Professional SQL Server High Availability and Disaster Recovery

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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Professional SQL Server 2012 Internals and Troubleshooting

Professional SQL Server 2012 Internals and Troubleshooting

Christian Bolton, James Rowland-Jones, Glenn Berry, Justin Langford, Gavin Payne, Amit Banerjee

Publisher Resources

ISBN: 9781789802597Supplemental Content