Notes on SQL

Random articles from a puzzled DBA

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 …

Continue reading

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 …

Continue reading