Some tips for using Merge Replication in SQL Server 2016 (Part 1) Avoid replicating text, ntext and image columns. These data types require more storage space and processing than other column data types. Consider setting the -OutputVerboseLevel parameter of the Merge Agent to 0. This parameter specifies whether the output should be verbose. There are three available values: 0 – […]
Tag: replication
Troubleshooting SQL Server 2014 Transactional Replication
Troubleshooting SQL Server 2014 Transactional Replication If you have problems with SQL Server 2014 transactional replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 Transactional replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]
Troubleshooting SQL Server 2014 Snapshot Replication
Troubleshooting SQL Server 2014 Snapshot Replication If you have problems with SQL Server 2014 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because some SQL Server 2014 snapshot replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time […]
SQL Server 2014 Snapshot Replication Optimization Tips
SQL Server 2014 Snapshot Replication Optimization Tips Do not configure the Distribution Agent to run continuously. Try to schedule the Distribution Agent to run at regular intervals instead of running continuously. By using it, you can decrease the total SQL Server overhead. Consider placing snapshot folder on a disk that is not used to store database or log files. Placing...
SQL Server 2014 Replication – Part 1
SQL Server 2014 Replication – Part 1 Author: Basit A. Farooq; You use replication to move data between servers. Replication is important in distributed environments, when archiving data, and as an inexpensive way to support high availability. In this topic, you will learn about the different types of replication, the components involved in replication, and the steps necessary to configure...
Replication
Pro-Center Video Programming for IT Professionals
Data File Sizes – How much is enough, if you don’t know what you got?
Pro-Center Video Programming for IT Professionals
Introduction to Replication
Pro-Center Video Programming for IT Professionals
Live: GoldenGate Replication – Configuring & Monitoring
Pro-Center Video Programming for IT Professionals
Using Transactional Replication as a High Availability Solution
Pro-Center Video Programming for IT Professionals