At SQLPASS 2015 I attended a presentation by Kendal Van Dyke, in which he told us that it was possible to log the actions of Replication to an output file. This was news to me, so I just had to have a closer look.
At SQLPASS 2015 I attended a presentation by Kendal Van Dyke, in which he told us that it was possible to log the actions of Replication to an output file. This was news to me, so I just had to have a closer look.
In the previous article I covered how to use the Replication Monitor to see what is happening with a Publication and to find out what the errors are. However, in some circumstances Replication Monitor may not show the entire picture with regard to the health of a Publication. Information can also be gleaned from the …
Most issues with Replication are detailed in either the Replication Monitor or in the history of the jobs used to run the Replication tasks. The following examples are based upon the Pull Subscription detailed in earlier articles. Replication Monitor This tool is available to anyone who is a member of the sysadmin role or replmonitor …