-
Book Overview & Buying
-
Table Of Contents
Introducing Microsoft SQL Server 2019
By :
A DBA's ability to provide access to the data for the business is an essential part of the role. Replication of data to secondary databases, either for reporting, data protection, or transformation, is an important feature. SQL Server 2019 on Linux now includes support for replication outside of VM replication with Site Recovery. The architecture support includes SQL Server 2019 on Linux in a container with the SQL Agent.
In any SQL Server replicated environment, there are three main identifiers:
Due to the goal of replication being failover if a failure occurs, a SQL Server instance that is part of a replication scenario can be any one of the three options. Replication configuration can be performed from the command line with stored procedures, or from SSMS Publication types are decided by the subscriber's needs: