"Farhan" wrote:

> Than you for your reply Mike,
>
> Basically, I want real time switching of database from web server when ever
> I lost running database connection so, I want web server to redirect
> automatically to the other database that is running on other server for high
> availability of database.
>
> Web server is not down but the connection between database server and web
> server has been broken.
>
> Have any idea or third party tools those provide these services.
>
> Farhan Iqbal
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > Look at Merge Replication. Lots about it in BOL and www.microsoft.com/sql
> > Creates quite a bit of overhead.
> >
> > If you are looking at high availability, how about some more web servers?
> > Does not help having a DB available when a Web Server is down.
> > Web servers can be load balanced (if the web site is coded in a way to
> > support it) and database servers can be clustered.
> >
> > Look on http://www.microsoft.com/windowsserver2003/default.mspx for the
> > technologies "clustering" and "load balancing".
> >
> > Regards
> > --------------------------------
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > IM: mike@epprecht.net
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> > "Farhan" <Farhan@discussions.microsoft.com> wrote in message
> > news:42601D68-9EE0-47A7-BCCE-A06B5759A7F0@microsoft.com...
> > > I have task in regards of synchronization of databases.
> > > Scenario is: I have 4 databases and 1 web server.
> > > When ever I lost connection due to any reason from any database, I want to
> > > switch automatically to other databases which are synchronizing each
> > others.
> > >
> > > One other thing is, how I can synchronize these all database to each
> > other.
> > >
> > > Can any one give me any idea or help in this regards I will be very thank
> > > full.
> > >
> > > Farhan Iqbal
> > >
> >
> >