Disaster Recovery Site Setup

All,
We are planning to setup disaster recovery in Vegas, actual one is in
SanFrancisco.
We have to synchronize the databases from SanFrancisco to Vegas.Ours is
24 X 7 ecommerce site.
Requirement for Disaster recovery is automatic failover and fail back
from one site to another site with minimum manual intervention.
Please advise if anybody has setup the disaster recovery.
Is Transactional Replication is good for two way replication?
Log shipping is good for just one way synchronization, and our log backups
will be 30 gb per day.
Has anybody has used wansync or goldengate softwares for the disaster
recovery setup?
Thanks.Hi,
SQL Server 2005 - Database Mirroring is the most suggested mechanism for
you. Database mirroring with a
Witness instance supported will do a automatic failover if the Primary
instance is down.
See the below URL on the article on setup of database mirroring.
http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
Thanks
Hari
SQL Server MVP
"DKRReddy" <dkrreddy@.hotmail.com> wrote in message
news:%23rbl0R7wGHA.1484@.TK2MSFTNGP04.phx.gbl...
> All,
> We are planning to setup disaster recovery in Vegas, actual one is in
> SanFrancisco.
> We have to synchronize the databases from SanFrancisco to Vegas.Ours
> is
> 24 X 7 ecommerce site.
> Requirement for Disaster recovery is automatic failover and fail back
> from one site to another site with minimum manual intervention.
> Please advise if anybody has setup the disaster recovery.
> Is Transactional Replication is good for two way replication?
> Log shipping is good for just one way synchronization, and our log backups
> will be 30 gb per day.
> Has anybody has used wansync or goldengate softwares for the disaster
> recovery setup?
>
> Thanks.
>|||You mention that you are a 24 x 7 ecommerce site. Besides the
databases, what are you doing to protect your web servers? If you host
your web servers in SanFrancisco and you lose the whole site, do you
have an automated means of redirecting the web traffic to the DR site
in Vegas?
In regards to your database solution, SQL Server 2005 - Database
Mirroring is fine for some things, however when running in the
automatic failover mode, you must use syncronous replication.
Syncronous replication across a WAN is going to kill the performance of
your primary database because it must wait for the write to commit on
the secondary server before it can commit on the primary server.
The other issue with SQL Server 2005 replication with automatic
failover is the placement of the witness server. This setup only truly
works if you have the witness server in a third location with seperate
communication paths to the primary and secondary data center.
Otherwise, with the witness server in the primary data center you will
not failover if you have a site loss (witness server is also gone).
With the witness server in the secondary data center you will have
false failovers if the WAN link goes down, because the witness server
and the secondary server will think the primary is unavailable.
If you go with SQL Server 2005 Database Mirroring, then I would forget
about the automatic failover mode and go with asyncronous replication
and a manual failover. Your other option is to go with a third party
solution such as LifeKeeper for SQL Server or one of the other ones you
mentioned.
David A. Bermingham, MCSE, MCSA:Messaging
Systems Engineer
www.steeleye.com
Hari Prasad wrote:
> Hi,
> SQL Server 2005 - Database Mirroring is the most suggested mechanism for
> you. Database mirroring with a
> Witness instance supported will do a automatic failover if the Primary
> instance is down.
> See the below URL on the article on setup of database mirroring.
> http://www.microsoft.com/technet/prodtechnol/sql/2005/dbmirror.mspx
> Thanks
> Hari
> SQL Server MVP
>
> "DKRReddy" <dkrreddy@.hotmail.com> wrote in message
> news:%23rbl0R7wGHA.1484@.TK2MSFTNGP04.phx.gbl...
> > All,
> > We are planning to setup disaster recovery in Vegas, actual one is in
> > SanFrancisco.
> > We have to synchronize the databases from SanFrancisco to Vegas.Ours
> > is
> > 24 X 7 ecommerce site.
> > Requirement for Disaster recovery is automatic failover and fail back
> > from one site to another site with minimum manual intervention.
> >
> > Please advise if anybody has setup the disaster recovery.
> >
> > Is Transactional Replication is good for two way replication?
> > Log shipping is good for just one way synchronization, and our log backups
> > will be 30 gb per day.
> >
> > Has anybody has used wansync or goldengate softwares for the disaster
> > recovery setup?
> >
> >
> > Thanks.
> >
> >