Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 12, 2004

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

By Steven Warren

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

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM