sql 2005 active/passive cluster options

Giganews Newsgroups
Subject: sql 2005 active/passive cluster options
Posted by:  tagtagbo…@gmail.com
Date: Mon, 31 Mar 2008

Hope someone can help me out with this or at least point me to the
right direction. We're in the process of implementing an application
that is storing data on a seperate SQL 2005 Standard box. Recently the
SQL server had an hardware fault causing application downtime for
several days. Luckily it wasn't in production - yet. According to the
application support, the only sql fault tolerance that works with
their product is an active/passive sql cluster.

Now I'm a newbie in this area but basically from what I've read in
terms of active/passive failover I need two identical servers (since
will use SQL Std version) + SAN. My company is a small-medium sized so
forking out $$ for that solution might be out of reach.

SO basically my question is, are there any other ways around this e.g.
by using existing SQL 2005 box (close to 2yrs old + Win2k3 Std)? We
also have another SQL 2000 Std box running Windows 2000 Std but don't
think that'll help much. Thanks!

Replies