High Availability over Distance

Hi,
I am looking for suggestions on creating a mirror site. Currently we have a
SQL server in a MS Cluster Environment. We will be creating another
clustered environment which will be 5+ miles away from the primary site.
What is the best way to create a mirror of the primary site?
I am looking for the Best option available (MS or third party). Currently I
am looking at Double Take and Replistor. We have sued Replistor in the past
with some good and very bad experiences. Primary goal is to make sure
secondary site is always up to date (within a minute or so). Money is not an
object (within reason, No Million $ options please :-) )
Thank you.
Hi Henrik,
Just be careful at using the high availabilty mode when the servers
(partners) are not on the same data center and pay special attention to
network reliability, network throughput and performance.
Take a look at this paper
Database Mirroring Best Practices and Performance Considerations
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"Henrik Davidsen" wrote:

> Try to read up on SQL Server's Mirroring feature.
>
> There are different modes the mirroring can operate in. One is a High
> Availability mode, whichs offers guarantee that the mirror is ALWAYS 100%
> up-to-date. That however produces some performance degrading. But read up on
> the mirroring
>
> The mirrorring funktionality is available within SQL Server 2005, so no
> extra expenses is nessecary.
> /Sjang
>
>
|||Thanks Guys. I will look into mirroring for sure.
What about any other options?
Thanks.
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...[vbcol=seagreen]
> Hi Henrik,
> Just be careful at using the high availabilty mode when the servers
> (partners) are not on the same data center and pay special attention to
> network reliability, network throughput and performance.
> Take a look at this paper
> Database Mirroring Best Practices and Performance Considerations
> http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/dbm_best_pract.mspx
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "Henrik Davidsen" wrote:
|||There are technologies available from SAN vendors. Although they probably
have million dollar + price tags. Call up EMC and tell them what you want to
do.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Dragon" <noSpam_baadil@.hotmail.com> wrote in message
news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
> Thanks Guys. I will look into mirroring for sure.
> What about any other options?
> Thanks.
>
> "Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
> news:25119072-74B9-4C84-BE55-042AFF85F735@.microsoft.com...
>
|||Thank you Jason.
"jason" <jason-r3move@.statisticsio.com> wrote in message
news:72BEA593-F945-4A39-B413-E25B118AFA7B@.microsoft.com...
> There are technologies available from SAN vendors. Although they probably
> have million dollar + price tags. Call up EMC and tell them what you want
> to do.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
>
> "Dragon" <noSpam_baadil@.hotmail.com> wrote in message
> news:unDj%23b4NIHA.4656@.TK2MSFTNGP03.phx.gbl...
>