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.
Replication
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 …
Having prepared the Distributor in the previous article it is now possible to create a Subscription. First of all create a test database and table on the Publisher (Publisher-A): A database is also required on the Subscriber (Subscriber-C): Now back to the Publisher. This server needs to be configured as a Publisher. The steps used …
By far the easiest way to create the Distributor is via the Wizard and examples abound of that – one such example is at SQL Server Central http://www.sqlservercentral.com/articles/Stairway+Series/72282/ . So why use scripts? Mainly for Disaster Recovery and consistency. Should you have to rebuild the server then running the scripts is easier and more reliable …
Actually, that isn’t entirely fair. I don’t have to eat sprouts, which is just as well. However, I do have to deal with Replication – certainly in my current job. Whereas my refusal to eat the Little Green Balls of Death won’t result in a divorce (because my wife, as wonderful as she is, does …
Notes on SQL 