SQL Server Log Shipping – Rapid Restart after Planned Failover
SQL Server Log Shipping – Rapid Restart after Planned Failover I was chatting with a group of DBAs the other day when the subject of SQL Server Log Shipping came up. The consensus between them was that Log Shipping is a great, cheap feature but that the time it took to get it restarted after […]
SQL Server Transactional Replication Latency Check
SQL Server Transactional Replication Latency Check SQL Server replication latency checks are often unreliable. Sure, you can automate tokens and the like, but in the end, you need to know “Am I synchronizing regularly?” and “Do I have a large number of undistributed commands?” Requirements: Setup: The first step is to establish a table to […]