You could try the log shipping feature in SQL2000 to
transfer your data to a standby server, if you've got one
or can afford to get one.

Cheers

A White
Workcover.com

>-----Original Message-----
>I don't have the budget to put in a SQLServer cluster:
right now am
>only running a single box in production with 2 load
balanced
>webservers in the front end.  Any ideas on how to get
some sort of
>"failover" redundancy on my one DB server without
putting in a DB
>Cluster. (even a hot-swap would be helpful -- I just
can't put up the
>$$ for the licensing to go to a cluster).
>
>Environment:
>CMS2002 Enterprise
>WIN2003 Standard Server
>SQL2000 Standard Server (I think)
>
>Thanks!
>.
>

[ Post a follow-up to this message ]