<aleu@vp.pl> wrote in message news:fdm2id$gj2$1@news.onet.pl...
> Hi everybody,
>
> Could you please advise me what would be the best method to synchronize
> MSSQL data in the following scenario:
>
> SiteA (live site) ----- T1 link ----- SiteB (redundant site)
>
> Each site consists of web server and MSSQL 2005 server. SiteA is the site
> that my customers normally use when accessing my store. SiteB is the
> backup site to which customers will be directed, should something happen
> to Internet connectivity of siteA. When the failover occurs, client
> request are pointing to my redundant web servers within a minute (this
> happens automatically, as I am using the hosted DNS service). I was
> wondering, what is the best method of keeping the database at siteB up to
> date with all the transactions that took place at siteA? I do not want my
> customers to access the redundant database if it does not contain all the
> transactions. What would you advise?
>
> Thanks,
> AL

"aleu@vp.pl" wrote:

> Hi everybody,
>
> Could you please advise me what would be the best method to synchronize
> MSSQL data in the following scenario:
>
> SiteA (live site) ----- T1 link ----- SiteB (redundant site)
>
> Each site consists of web server and MSSQL 2005 server. SiteA is the
> site that my customers normally use when accessing my store. SiteB is
> the backup site to which customers will be directed, should something
> happen to Internet connectivity of siteA. When the failover occurs,
> client request are pointing to my redundant web servers within a minute
> (this happens automatically, as I am using the hosted DNS service). I
> was wondering, what is the best method of keeping the database at siteB
> up to date with all the transactions that took place at siteA? I do not
> want my customers to access the redundant database if it does not
> contain all the transactions. What would you advise?
>
> Thanks,
> AL