Search icon CANCEL
Subscription
0
Cart icon
Cart
Close icon
You have no products in your basket yet
Save more on your purchases!
Savings automatically calculated. No voucher code required
Arrow left icon
All Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Newsletters
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Professional SQL Server High Availability and Disaster Recovery

You're reading from  Professional SQL Server High Availability and Disaster Recovery

Product type Book
Published in Jan 2019
Publisher Packt
ISBN-13 9781789802597
Pages 564 pages
Edition 1st Edition
Languages
Concepts
Author (1):
Ahmad Osama Ahmad Osama
Profile icon Ahmad Osama
Toc

Table of Contents (9) Chapters close

Professional SQL Server High Availability and Disaster Recovery
Preface
1. Getting Started with SQL Server HA and DR 2. Transactional Replication 3. Monitoring Transactional Replication 4. AlwaysOn Availability Groups 5. Managing AlwaysOn Availability Groups 6. Configuring and Managing Log Shipping Appendix

Real-World Transactional Replication Problems and Solutions


This section discusses some of the common real-world transactional replication problems that may occur in a transactional replication configuration. There are no specific patterns for these problems. Almost all of these problems can be solved without having to reconfigure the replication.

Transactional replication doesn't require that much management once configured. However, you'd have to look at issues that may occur from time to time. In this section, we'll look at some of those issues.

We can group these issues under the following categories:

  • Configuration issues

  • Data issues

  • Performance issues

Note

This categorization is done for understanding, and is not the standard categorization from Microsoft. This lesson doesn't cover all issues. It covers common issues and explains the solutions to them in a way so that you can fix other issues.

Configuration Issues

As the name suggests, these are issues that may occur if transactional replication...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €14.99/month. Cancel anytime