How to setup a backup server for SQL Server2005 for production (in case the primary server fails

I currently have a SQL Server cluster setup with a Primary DB Server SERVER1 and the Standby server SERVER2. SERVER1 has been failing more than normal is the past few weeks and its takes upto 5 mins for SERVER2 realize that SERVER1 is down. I am looking for a better way to implement a backup server on production with minimum downtime. Please adivse..

you have two options one is Database mirroring and other is log shipping in sql 2005..........but i advise you to go with db mirroring as the downtime is less in high availability mode as you have a witness server and hence the failover will be automatic and within few seconds............but in log shipping only manual failover is possible........refer,

http://dumthata.com/sqlchn/articles/dbmrr.htm

http://dumthata.com/sqlchn/articles/lship.htm

Going forward pls post in the appropriate forum as it would be easier to read through and answer....

How to set up replication from SQL Server 2005 to MySQL through ODBC

Hi,
Can anyone please provide me with a step-by-step explanation on how to
replicate data (snapshot replication) from a table in a SQL Server
2005 database to a table in a MySQL database through an ODBC
connection?
I have already created a publication, but have not succeeded in
successfully adding a subscription. I know that I have to use the
stored procedures "sp_addsubscription" and
"sp_addpushsubscription_agent", but cannot figure out how to set up
the parameters to get it to work. Any help on this issue would be
greatly appreciated.
Thanks
This is not supported in SQL 2005. It was in SQL 2000 but there was a bug
last time I checked.
<ronald.debruin@.ecorys.com> wrote in message
news:1177595848.403994.88300@.n35g2000prd.googlegro ups.com...
> Hi,
> Can anyone please provide me with a step-by-step explanation on how to
> replicate data (snapshot replication) from a table in a SQL Server
> 2005 database to a table in a MySQL database through an ODBC
> connection?
> I have already created a publication, but have not succeeded in
> successfully adding a subscription. I know that I have to use the
> stored procedures "sp_addsubscription" and
> "sp_addpushsubscription_agent", but cannot figure out how to set up
> the parameters to get it to work. Any help on this issue would be
> greatly appreciated.
> Thanks
>