High Availability with SQL 2000 and Double-Take - Page 2

April 12, 2004

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.

Click for larger image

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