<foghorn69newspostalias@discussions.microsoft.com> wrote in message
news:962C32EB-6C89-4544-A19B-453D963F0C67@microsoft.com...
>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!!
>
>

<foghorn69newspostalias@discussions.microsoft.com> wrote in message
news:0816F936-2F3F-4E5B-B8BF-60CCDB20CE99@microsoft.com...
> Where can I find info on this?
>
> "Kevin3NF" wrote:
>
> > replication isn't always the best option for DR....have you looked into
Log
> > Shipping?
> >
> > --
> > Kevin Hill
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> >
> > www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.
> >
> > www.experts-exchange.com - experts compete for points to answer your
> > questions
> >
> >
> > "foghorn69@news.postalias"
> > <foghorn69newspostalias@discussions.microsoft.com> wrote in message
> > news:962C32EB-6C89-4544-A19B-453D963F0C67@microsoft.com...
> > >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!!
> > >
> > >
> >
> >
> >