Creating a Replication Set
We are now ready to create our replication set that will
mirror and replicate to our Target server. In order to perform this, right-click
on your Source machine and choose New Replication Set and enter the name
of the replication set as shown in Figure E.
Next, choose the following directories you would like to
replicate onto the Target machine. For SQL Server, I chose the following: Data
and Log files (Figure F.)
Note: Do not forget to right-click on the replication set
name and choose save.
Next, drag and drop your replication set onto the Target
machine (Beast) as shown in Figure G. As you can see the Source Server, Replication
Set, Target Server and IP address are automatically configured. I recommend
that you just review the screen to make sure that you did not make any
mistakes. When your review is complete, remember to click connect to start the
mirror and replication process (Figure H.)
Figure F.
Figure G.
Figure H.
Finally, you can test mirroring
and replication by creating new databases, tables, indexes, etc on the Source
server and seeing it appear almost instantly on the Target server. In my next
article, we will build upon what we have learned here by showing you how to
configure a failover/failback to the Target/Source SQL Server automatically. We
will also show you what to do in order to restore the SQL Server data on the
Source machine to bring the server back online.
»
See All Articles by Columnist Steven S. Warren