SQL Homework – October 2022 – Replication part 2

Leave a comment

October 4, 2022 by Kenneth Fisher

In August we started taking a look at replication. We learned some of the terms used, and set up a (probably) pretty basic example of replication. Now it’s time to work with it a bit more.

  • Open the Replication Monitor.
    • Right click on different entries. See what options you have.
    • Left click on them and see what shows up.
    • Insert a tracer. What does the tracer do? What does the output mean?
    • Configure an alert. There are a fair number of options here but hopefully you’ve created an alert before so this should be pretty familiar.
    • If you have the option connect to a listener for an instance that has replication and open the replication monitor. What was different?
  • Go to the subscriber of an publication. Insert a row into one of the replicated tables. To make this easier make sure that table has a primary key. Then go back to the publisher and insert the same row into the same table. Give it a few minutes and check the replication monitor again. You should see that this is a particularly bad idea. How do you fix it? How do you prevent it?
  • Add a new table to the subscriber database. Insert some data into that table. Did that cause a problem with replication? What are some reasons you might do this? What are some reasons why you shouldn’t? How do you avoid problems?
  • Modify a replicated stored procedure. Modify a replicated table. Add a column, or change a column’s datatype. Take a look at the subscriber. Did the changes make it there? How about if you add an index?
  • Add a second subscriber to a publication. Insert some rows into a replicated table (to be clear add it on the publisher). Take a look at both subscribers. Did the data make it? Why might you want multiple subscribers?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: