Notes on SQL

Random articles from a puzzled DBA

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

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 …

Continue reading

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 …

Continue reading