Scripting a Publication is useful for both Disaster Recovery and copying a Publication to a test environment. If you use the Wizard each time then you have to make sure that you’re consistent with the options and choices made in Live and once again on the Test (or DR) server. By creating the script you …
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 …
Notes on SQL 