SQL Replication How To

From: foghorn69@xxxxxxxxxxxxxx <foghorn69newspostalias@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 19 Jul 2005 13:14:03 -0700

I currently have a two SQL Servers in a Windows 2003 Cluster with the
database sitting on a directly attached fiber channel storage array (EMC
CX300). I have another SQL Server (Standalone) in a remote location that is
going to be used for disaster recovery. The cluster and the standalone
server are connected over a private T1 WAN line.

What is the best way to replicate the data from the cluster to the
standalone SQL server in cae of a disaster? Can you schedule it to replicate
at night? Would transactional replication be the best approach?? Is there a
clear and concise "How To"

Thanks!!

.

Follow-Ups:
- Re: SQL Replication How To
  - From: Kevin3NF

Prev by Date: New kind of merge repl error floating point exception??
Next by Date: Re: Can't use replication after renaming server. Please help!!!
Previous by thread: New kind of merge repl error floating point exception??
Next by thread: Re: SQL Replication How To
Index(es):
- Date
- Thread

Relevant Pages

Re: Migrate existing standalone to cluster
... To create a database with a case-sensitive collation, ... Finally, remove the standalone. ... Columnist, SQL Server Professional ... >> the DB's to the cluster? ...
(microsoft.public.sqlserver.clustering)
Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
(microsoft.public.sqlserver.clustering)
Re: Cluster will not fail over.
... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
(microsoft.public.sqlserver.clustering)
Re: active/passive with multiple instances
... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
(microsoft.public.sqlserver.clustering)
Re: High Availability
... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
(microsoft.public.sqlserver.clustering)