Some tips for using Snapshot Replication in SQL Server 2016 Avoid publishing unnecessary data. Try to restrict the amount of published data. This can results in good performance benefits, because SQL Server will publish only the amount of data required. This can reduce network traffic and boost the overall replication performance. Do not configure the Distribution Agent to run continuously. […]
Tag: subscription
Troubleshooting SQL Server 2014 Reporting Services
Troubleshooting SQL Server 2014 Reporting Services If you have problems with SQL Server 2014 Reporting Services (SSRS 2014), review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2014 service pack. Because many SQL Server 2014 Reporting Services bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At […]
Troubleshooting SQL Server 2012 Snapshot Replication
Troubleshooting SQL Server 2012 Snapshot Replication If you have problems with SQL Server 2012 snapshot replication, review this troubleshooting checklist to find potential solutions. 1. Install the latest SQL Server 2012 service pack. Because some SQL Server 2012 snapshot replication bugs were fixed in SQL Server service packs, you should install the latest SQL Server service pack. At the time...
Tips for using SQL Server 2012 Snapshot Replication
Tips for using SQL Server 2012 Snapshot Replication SQL Server 2012 introduces AlwaysOn Availability Groups. This is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise and supports a failover environment for a discrete set of user databases, known as availability...