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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

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

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




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


















Thanks for your registration, follow us on our social networks to keep up-to-date