Looking for HA solution that eliminates data loss

What High Availability/Disaster Recovery Solutions are out there to prevent
any data loss when a server or site goes down.
I know there is clustering services. Are there any other ways of achieving
no data loss. I can think of 2 phase commit , but that introduces latency I
would imagine.
Also is there a way to handle 2 phase commit outside the application level.
I believe the 2 phase commit has to be programmed with SQL right ?
Looking to hear the solutions you use to prevent from a server and site
outage
See if this helps:
http://www.microsoft.com/sql/techinf...ilability.mspx
David Portas
SQL Server MVP
|||In addition to David's post, SQL Server 2005 will have database mirroring, which is no-loss
mirroring of data with failover in only a few seconds. More information on SM SQL Server home page.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Hassan" <fatima_ja@.hotmail.com> wrote in message news:e%23faQBLmFHA.708@.TK2MSFTNGP09.phx.gbl...
> What High Availability/Disaster Recovery Solutions are out there to prevent
> any data loss when a server or site goes down.
> I know there is clustering services. Are there any other ways of achieving
> no data loss. I can think of 2 phase commit , but that introduces latency I
> would imagine.
> Also is there a way to handle 2 phase commit outside the application level.
> I believe the 2 phase commit has to be programmed with SQL right ?
> Looking to hear the solutions you use to prevent from a server and site
> outage
>
>